APPS.PAY_CA_PAYREG_EXTRACT_PKG dependencies on PAY_ORG_PAYMENT_METHODS_F

Line 706: ,pay_org_payment_methods_f_tl popm_tl

702: ,hr_all_organization_units_tl hou
703: ,pay_all_payrolls_f pap
704: ,pay_payment_types_tl ppt_tl
705: ,pay_payment_types ppt
706: ,pay_org_payment_methods_f_tl popm_tl
707: ,pay_org_payment_methods_f popm
708: ,pay_pre_payments ppp
709: ,(select distinct paa_pre.assignment_action_id /* Locked Action Id */
710: --,paa_run.tax_unit_id -- commented for bug 7280782

Line 707: ,pay_org_payment_methods_f popm

703: ,pay_all_payrolls_f pap
704: ,pay_payment_types_tl ppt_tl
705: ,pay_payment_types ppt
706: ,pay_org_payment_methods_f_tl popm_tl
707: ,pay_org_payment_methods_f popm
708: ,pay_pre_payments ppp
709: ,(select distinct paa_pre.assignment_action_id /* Locked Action Id */
710: --,paa_run.tax_unit_id -- commented for bug 7280782
711: ,paa_pre.tax_unit_id -- Added for bug 7280782

Line 885: from pay_org_payment_methods_f

881:
882: /* Third Party Payment Check flag, to fix bug#2745577 */
883: cursor c_tp_pmt_check (cp_org_pmt_method_id number) IS
884: select 'Y'
885: from pay_org_payment_methods_f
886: where org_payment_method_id = cp_org_pmt_method_id
887: and defined_balance_id is null;
888:
889: /* New Query to get the Payee_type, Payee_id

Line 1018: ln_defined_balance_id pay_org_payment_methods_f.defined_balance_id%TYPE; /* BUG: 5383895 added */

1014: lv_payroll_actid NUMBER;
1015: lv_void_date DATE;
1016: lv_payment_status VARCHAR2(10);
1017:
1018: ln_defined_balance_id pay_org_payment_methods_f.defined_balance_id%TYPE; /* BUG: 5383895 added */
1019:
1020: BEGIN
1021: hr_utility.set_location(gv_package_name || '.payment_extract', 10);
1022: /* hr_utility.trace_on(null, 'ORACLE'); */