DBA Data[Home] [Help]

APPS.PAY_JP_PAYSLIP_ARCHIVE dependencies on PAY_PRE_PAYMENTS

Line 359: -- Both master and child assignment actions can have PAY_PRE_PAYMENTS record.

355: and pppa.action_type in ('P', 'U');
356: --
357: -- A master prepayments assignment action can have multiple child assignment actions,
358: -- but child can not have child assignment actions.
359: -- Both master and child assignment actions can have PAY_PRE_PAYMENTS record.
360: -- PAY_PRE_PAYMENTS indicates source "Run" assignment_action_id.
361: --
362: cursor csr_payment(
363: cp_prepay_assignment_action_id number,

Line 360: -- PAY_PRE_PAYMENTS indicates source "Run" assignment_action_id.

356: --
357: -- A master prepayments assignment action can have multiple child assignment actions,
358: -- but child can not have child assignment actions.
359: -- Both master and child assignment actions can have PAY_PRE_PAYMENTS record.
360: -- PAY_PRE_PAYMENTS indicates source "Run" assignment_action_id.
361: --
362: cursor csr_payment(
363: cp_prepay_assignment_action_id number,
364: cp_prepay_effective_date date) is

Line 389: pay_pre_payments ppp,

385: from pay_assignment_actions paa
386: connect by prior paa.assignment_action_id = paa.source_action_id
387: start with paa.assignment_action_id = cp_prepay_assignment_action_id
388: ) v,
389: pay_pre_payments ppp,
390: pay_org_payment_methods_f opm,
391: pay_org_payment_methods_f_tl opmtl,
392: pay_payment_types ppt,
393: pay_external_accounts pea,