APPS.PAY_US_EMPLOYEE_PAYSLIP_WEB dependencies on PAY_PAYMENT_TYPES

Line 271: from pay_payment_types ppt,

267: (cp_assignment_action_id number
268: ,cp_payment_category varchar2
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

Line 844: from pay_payment_types ppt,

840: /* Cursor to get the how employee is paid */
841: cursor c_pre_payment_method
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

Line 2536: from pay_payment_types ppt

2532:
2533: cursor cur_payment_typ(p_legislation_code in varchar2
2534: ,p_org_pay_meth_id IN NUMBER) is
2535: select '1'
2536: from pay_payment_types ppt
2537: ,pay_org_payment_methods_f popm
2538: where popm.org_payment_method_id = p_org_pay_meth_id
2539: and popm.payment_type_id = ppt.payment_type_id
2540: and ppt.territory_code = p_legislation_code

Line 2903: FROM pay_payment_types ppt,

2899: /* Cursor to get the how employee is paid */
2900: CURSOR c_pre_payment_method
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