APPS.HR_PERSONAL_PAY_METHOD_API dependencies on PAY_ORG_PAYMENT_METHODS_F

Line 263: , pay_org_payment_methods_f opm

259: ) is
260: select nvl(to_char(opm.defined_balance_id), 'Y') third_party
261: , nvl(ppt.validation_days, 0) validation_days
262: from pay_personal_payment_methods_f ppm
263: , pay_org_payment_methods_f opm
264: , pay_payment_types ppt
265: where ppm.personal_payment_method_id = p_personal_payment_method_id
266: and p_effective_date between
267: ppm.effective_start_date and ppm.effective_end_date

Line 682: from pay_org_payment_methods_f opm,

678: --
679: -- Bug 4644507. Removed the usage of per_business_groups from the cursor.
680: cursor csr_is_valid is
681: select null
682: from pay_org_payment_methods_f opm,
683: pay_payment_types ppt
684: where opm.org_payment_method_id = p_org_payment_method_id
685: and p_effective_date
686: between opm.effective_start_date

Line 692: from pay_org_payment_methods_f opm

688: and ppt.payment_type_id = opm.payment_type_id ;
689: --
690: cursor csr_chk_pay_type is
691: select pyt.category
692: from pay_org_payment_methods_f opm
693: , pay_payment_types pyt
694: where p_org_payment_method_id = opm.org_payment_method_id
695: and opm.payment_type_id = pyt.payment_type_id
696: and p_effective_date between opm.effective_start_date

Line 703: pay_org_payment_methods_f opm

699: cursor csr_ppm_info_category ( p_org_payment_method_id number,
700: p_effective_date date) is
701: select decode(ppt.territory_code,null,null,ppt.territory_code||'_')||UPPER(ppt.payment_type_name) ppm_information_category
702: from pay_payment_types ppt,
703: pay_org_payment_methods_f opm
704: where opm.org_payment_method_id = p_org_payment_method_id
705: and p_effective_date between opm.effective_start_date and opm.effective_end_date
706: and opm.payment_type_id = ppt.payment_type_id;
707: --

Line 1943: , pay_org_payment_methods_f opm

1939: --
1940: cursor csr_chk_pay_type is
1941: select pyt.category
1942: from pay_personal_payment_methods_f ppm
1943: , pay_org_payment_methods_f opm
1944: , pay_payment_types pyt
1945: where ppm.personal_payment_method_id = p_personal_payment_method_id
1946: and p_effective_date between
1947: ppm.effective_start_date and ppm.effective_end_date

Line 1958: pay_org_payment_methods_f opm,

1954: cursor csr_ppm_info_category ( p_personal_payment_method_id number,
1955: p_effective_date date) is
1956: select decode(ppt.territory_code,null,null,ppt.territory_code||'_')||UPPER(ppt.payment_type_name) ppm_information_category
1957: from pay_payment_types ppt,
1958: pay_org_payment_methods_f opm,
1959: pay_personal_payment_methods_f ppm
1960: where ppm.personal_payment_method_id = p_personal_payment_method_id
1961: and p_effective_date between ppm.effective_start_date and ppm.effective_end_date
1962: and opm.org_payment_method_id = ppm.org_payment_method_id