DBA Data[Home] [Help]

APPS.PAY_US_ACTION_ARCH dependencies on PAY_US_PAYMENT_PKG

Line 6233: ,TO_CHAR(pay_us_payment_pkg.get_trx_date( NULL, --:business_group_id,

6229: /* Following cursor is for NEW Wage Attachment Architecture elements */
6230: cursor c_get_att_no_new is
6231: select peev.screen_entry_value garn_ref_no
6232: ,round(ppp.value ,2)
6233: ,TO_CHAR(pay_us_payment_pkg.get_trx_date( NULL, --:business_group_id,
6234: NULL, --:ppa_payroll_action_id,
6235: NULL,
6236: NULL, --:ppa_payroll_id,
6237: NULL, --:ppa_consolidation_set_id,

Line 6316: ,TO_CHAR(pay_us_payment_pkg.get_trx_date( NULL, --:business_group_id,

6312: /* Following cursor is for OLD Wage Attachment Architecture elements */
6313: cursor c_get_att_no_old is
6314: select peev.screen_entry_value garn_ref_no
6315: ,round(ppp.value ,2)
6316: ,TO_CHAR(pay_us_payment_pkg.get_trx_date( NULL, --:business_group_id,
6317: NULL, --:ppa_payroll_action_id,
6318: NULL,
6319: NULL, --:ppa_payroll_id,
6320: NULL, --:ppa_consolidation_set_id,