3 queries found for "Account Automatic Payment"
Get all from Account Automatic Payment
select *
from CI_ACCT_APAY
uploaded by Nuno Rodrigues
Get specific Account Automatic Payment
select *
from CI_ACCT_APAY
where
ACCT_ID = 'XXXX'
uploaded by Nuno Rodrigues
Retrieve Account Autopay Details
SELECT
*
FROM
CI_ACCT_APAY
WHERE
ACCT_ID = 'INSERT_ACCOUNT_ID'
AND (
START_DT <= 'INSERT_DATE_TO_CHECK___TODAYS_DATE_FOR_CURRENT' AND (END_DT IS NULL OR END_DT >= 'INSERT_DATE_TO_CHECK___TODAYS_DATE_FOR_CURRENT')
OR START_DT > 'INSERT_DATE_TO_CHECK___TODAYS_DATE_FOR_CURRENT'
)
uploaded by Nuno Rodrigues