APPS.HR_PERSONAL_PAY_METHOD_API dependencies on PAY_PAYMENT_TYPES

Line 264: , pay_payment_types ppt

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
268: and opm.org_payment_method_id = ppm.org_payment_method_id

Line 687: pay_payment_types ppt

683: -- Bug 4644507. Removed the usage of per_business_groups from the cursor.
684: cursor csr_is_valid is
685: select null
686: from pay_org_payment_methods_f opm,
687: pay_payment_types ppt
688: where opm.org_payment_method_id = p_org_payment_method_id
689: and p_effective_date
690: between opm.effective_start_date
691: and opm.effective_end_date

Line 697: , pay_payment_types pyt

693: --
694: cursor csr_chk_pay_type is
695: select pyt.category
696: from pay_org_payment_methods_f opm
697: , pay_payment_types pyt
698: where p_org_payment_method_id = opm.org_payment_method_id
699: and opm.payment_type_id = pyt.payment_type_id
700: and p_effective_date between opm.effective_start_date
701: and opm.effective_end_date;

Line 706: from pay_payment_types ppt,

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

Line 2139: , pay_payment_types pyt

2135: cursor csr_chk_pay_type is
2136: select pyt.category
2137: from pay_personal_payment_methods_f ppm
2138: , pay_org_payment_methods_f opm
2139: , pay_payment_types pyt
2140: where ppm.personal_payment_method_id = p_personal_payment_method_id
2141: and p_effective_date between
2142: ppm.effective_start_date and ppm.effective_end_date
2143: and opm.org_payment_method_id = ppm.org_payment_method_id

Line 2152: from pay_payment_types ppt,

2148: --
2149: cursor csr_ppm_info_category ( p_personal_payment_method_id number,
2150: p_effective_date date) is
2151: select decode(ppt.territory_code,null,null,ppt.territory_code||'_')||UPPER(ppt.payment_type_name) ppm_information_category
2152: from pay_payment_types ppt,
2153: pay_org_payment_methods_f opm,
2154: pay_personal_payment_methods_f ppm
2155: where ppm.personal_payment_method_id = p_personal_payment_method_id
2156: and p_effective_date between ppm.effective_start_date and ppm.effective_end_date