APPS.PAY_US_EMPLOYEE_PAYSLIP_WEB dependencies on PAY_PRE_PAYMENTS

Line 273: pay_pre_payments ppp

269: ,cp_legislation_code varchar2) is
270: select ppp.pre_payment_id
271: from pay_payment_types ppt,
272: pay_org_payment_methods_f popm,
273: pay_pre_payments ppp
274: where ppp.assignment_action_id = cp_assignment_action_id
275: and popm.org_payment_method_id = ppp.org_payment_method_id
276: and popm.defined_balance_id is not null
277: and ppt.payment_type_id = popm.payment_type_id

Line 356: from pay_pre_payments ppp

352: select 1
353: from dual
354: where not exists
355: (select 1
356: from pay_pre_payments ppp
357: where ppp.assignment_action_id = cp_prepayment_action_id
358: );
359:
360: lv_reversal_exists VARCHAR2(1);

Line 846: pay_pre_payments ppp

842: (cp_assignment_action_id number) is
843: select ppp.pre_payment_id
844: from pay_payment_types ppt,
845: pay_org_payment_methods_f popm,
846: pay_pre_payments ppp
847: where ppp.assignment_action_id = cp_assignment_action_id
848: and popm.org_payment_method_id = ppp.org_payment_method_id
849: and popm.defined_balance_id is not null
850: and ppt.payment_type_id = popm.payment_type_id;

Line 1711: from pay_pre_payments ppp,

1707: ,cp_pre_payment_id in number) is
1708: select decode(ppa_pymt.action_type,
1709: 'M', to_char(NVL(ppp.source_action_id,cp_pre_payment_action)),
1710: paa_pymt.serial_number)
1711: from pay_pre_payments ppp,
1712: pay_assignment_actions paa_pymt,
1713: pay_payroll_actions ppa_pymt,
1714: pay_action_interlocks pai
1715: where pai.locked_action_id = cp_pre_payment_action

Line 2905: pay_pre_payments ppp

2901: (cp_assignment_action_id NUMBER) IS
2902: SELECT ppp.pre_payment_id
2903: FROM pay_payment_types ppt,
2904: pay_org_payment_methods_f popm,
2905: pay_pre_payments ppp
2906: WHERE ppp.assignment_action_id = cp_assignment_action_id
2907: AND popm.org_payment_method_id = ppp.org_payment_method_id
2908: AND popm.defined_balance_id IS NOT NULL
2909: AND ppt.payment_type_id = popm.payment_type_id;