APPS.PAY_US_DEPOSIT_ADVICE_PKG dependencies on PAY_PRE_PAYMENTS

Line 54: is there pay_pre_payments.

50: 04-AUG-2004 schauhan 115.3 3512116 Added assignment_set_id in the return list of
51: procedure get_payroll_action.
52: 18-OCT-2004 schauhan 115.4 3928576 Made changes to cursor c_actions_zero_pay to check
53: only if assignment_action_id for master action is
54: is there pay_pre_payments.
55: 14-MAR-2005 sackumar 115.5 4222032 Change in the Range Cursor removing redundant
56: use of bind Variable (:payroll_action_id)
57: 29-MAR-2005 sackumar 115.6 4222032 Removing GSCC Errors
58: 29-APR-2005 sackumar 115.7 3812668 Merge the concept of Zero pay cursor into c_actions

Line 317: pay_pre_payments ppp,

313: from pay_action_interlocks pai_mag,
314: pay_assignment_actions paa_mag,
315: pay_payroll_actions ppa_mag,
316: pay_org_payment_methods_f popm,
317: pay_pre_payments ppp,
318: pay_payment_types ppt
319: where pai_mag.locked_action_id = cp_prepayment_action_id
320: and pai_mag.locking_Action_id = paa_mag.assignment_action_id
321: and paa_mag.payroll_action_id = ppa_mag.payroll_action_id

Line 344: from pay_pre_payments ppp ,

340: select 1
341: from dual
342: where not exists
343: (select 1
344: from pay_pre_payments ppp ,
345: pay_org_payment_methods_f popm
346: where ppp.assignment_action_id = cp_prepayment_action_id
347: and popm.ORG_PAYMENT_METHOD_ID = ppp.org_payment_method_id
348: and popm.defined_balance_id is not NULL );

Line 775: FROM pay_pre_payments ppp,

771: and paf2.payroll_id + 0 = ppf.payroll_id
772: and act.assignment_id between stperson and endperson
773: -- No run results.
774: and NOT EXISTS (SELECT ' '
775: FROM pay_pre_payments ppp,
776: pay_org_payment_methods_f popm
777: WHERE ppp.assignment_action_id = decode(act.source_action_id,NULL
778: ,act.assignment_action_id,
779: act.source_action_id) --Bug 3928576.Check only for master actions.

Line 835: from pay_pre_payments ppp,

831: *****************************************************************/
832: cursor c_payments (cp_pre_pymt_action_id in number,
833: cp_effective_date in date) is
834: select distinct ppp.source_action_id
835: from pay_pre_payments ppp,
836: pay_personal_payment_methods_f pppm
837: where ppp.assignment_action_id = cp_pre_pymt_action_id
838: and pppm.personal_payment_method_id = ppp.personal_payment_method_id
839: and pppm.external_account_id is not null

Line 933: FROM pay_pre_payments ppp,

929: )
930:
931: -- No run results.
932: and NOT EXISTS (SELECT '' ''
933: FROM pay_pre_payments ppp,
934: pay_org_payment_methods_f popm
935: WHERE ppp.assignment_action_id = decode(act.source_action_id,NULL
936: ,act.assignment_action_id,
937: act.source_action_id) --Bug 3928576.Check only for master actions.