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 312: pay_pre_payments ppp,

308: from pay_action_interlocks pai_mag,
309: pay_assignment_actions paa_mag,
310: pay_payroll_actions ppa_mag,
311: pay_org_payment_methods_f popm,
312: pay_pre_payments ppp,
313: pay_payment_types ppt
314: where pai_mag.locked_action_id = cp_prepayment_action_id
315: and pai_mag.locking_Action_id = paa_mag.assignment_action_id
316: and paa_mag.payroll_action_id = ppa_mag.payroll_action_id

Line 339: from pay_pre_payments ppp ,

335: select 1
336: from dual
337: where not exists
338: (select 1
339: from pay_pre_payments ppp ,
340: pay_org_payment_methods_f popm
341: where ppp.assignment_action_id = cp_prepayment_action_id
342: and popm.ORG_PAYMENT_METHOD_ID = ppp.org_payment_method_id
343: and popm.defined_balance_id is not NULL );

Line 765: FROM pay_pre_payments ppp,

761: and paf2.payroll_id + 0 = ppf.payroll_id
762: and act.assignment_id between stperson and endperson
763: -- No run results.
764: and NOT EXISTS (SELECT ' '
765: FROM pay_pre_payments ppp,
766: pay_org_payment_methods_f popm
767: WHERE ppp.assignment_action_id = decode(act.source_action_id,NULL
768: ,act.assignment_action_id,
769: act.source_action_id) --Bug 3928576.Check only for master actions.

Line 825: from pay_pre_payments ppp,

821: *****************************************************************/
822: cursor c_payments (cp_pre_pymt_action_id in number,
823: cp_effective_date in date) is
824: select distinct ppp.source_action_id
825: from pay_pre_payments ppp,
826: pay_personal_payment_methods_f pppm
827: where ppp.assignment_action_id = cp_pre_pymt_action_id
828: and pppm.personal_payment_method_id = ppp.personal_payment_method_id
829: and pppm.external_account_id is not null

Line 923: FROM pay_pre_payments ppp,

919: )
920:
921: -- No run results.
922: and NOT EXISTS (SELECT '' ''
923: FROM pay_pre_payments ppp,
924: pay_org_payment_methods_f popm
925: WHERE ppp.assignment_action_id = decode(act.source_action_id,NULL
926: ,act.assignment_action_id,
927: act.source_action_id) --Bug 3928576.Check only for master actions.