DBA Data[Home] [Help]

APPS.PAY_US_EMPLOYEE_PAYSLIP_WEB dependencies on PAY_ORG_PAYMENT_METHODS_F

Line 208: pay_org_payment_methods_f popm,

204: ,cp_payment_category varchar2
205: ,cp_legislation_code varchar2) is
206: select ppp.pre_payment_id
207: from pay_payment_types ppt,
208: pay_org_payment_methods_f popm,
209: pay_pre_payments ppp
210: where ppp.assignment_action_id = cp_assignment_action_id
211: and popm.org_payment_method_id = ppp.org_payment_method_id
212: and popm.defined_balance_id is not null

Line 462: pay_org_payment_methods_f popm,

458: cursor c_pre_payment_method
459: (cp_assignment_action_id number) is
460: select ppp.pre_payment_id
461: from pay_payment_types ppt,
462: pay_org_payment_methods_f popm,
463: pay_pre_payments ppp
464: where ppp.assignment_action_id = cp_assignment_action_id
465: and popm.org_payment_method_id = ppp.org_payment_method_id
466: and popm.defined_balance_id is not null

Line 1891: ,pay_org_payment_methods_f popm

1887: cursor cur_payment_typ(p_legislation_code in varchar2
1888: ,p_org_pay_meth_id IN NUMBER) is
1889: select '1'
1890: from pay_payment_types ppt
1891: ,pay_org_payment_methods_f popm
1892: where popm.org_payment_method_id = p_org_pay_meth_id
1893: and popm.payment_type_id = ppt.payment_type_id
1894: and ppt.territory_code = p_legislation_code
1895: and ppt.category = 'CH';