DBA Data[Home] [Help]

APPS.PAY_JP_PAYSLIP_ARCHIVE dependencies on PAY_PRE_PAYMENTS

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

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

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

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

Line 390: pay_pre_payments ppp,

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