APPS.PAY_CA_PAYREG_EXTRACT_PKG dependencies on PAY_ORG_PAYMENT_METHODS_F

Line 696: ,pay_org_payment_methods_f_tl popm_tl

692: ,hr_all_organization_units_tl hou
693: ,pay_all_payrolls_f pap
694: ,pay_payment_types_tl ppt_tl
695: ,pay_payment_types ppt
696: ,pay_org_payment_methods_f_tl popm_tl
697: ,pay_org_payment_methods_f popm
698: ,pay_pre_payments ppp
699: ,(select distinct paa_pre.assignment_action_id /* Locked Action Id */
700: ,paa_run.tax_unit_id

Line 697: ,pay_org_payment_methods_f popm

693: ,pay_all_payrolls_f pap
694: ,pay_payment_types_tl ppt_tl
695: ,pay_payment_types ppt
696: ,pay_org_payment_methods_f_tl popm_tl
697: ,pay_org_payment_methods_f popm
698: ,pay_pre_payments ppp
699: ,(select distinct paa_pre.assignment_action_id /* Locked Action Id */
700: ,paa_run.tax_unit_id
701: ,ppa_pre.date_earned

Line 868: from pay_org_payment_methods_f

864:
865: /* Third Party Payment Check flag, to fix bug#2745577 */
866: cursor c_tp_pmt_check (cp_org_pmt_method_id number) IS
867: select 'Y'
868: from pay_org_payment_methods_f
869: where org_payment_method_id = cp_org_pmt_method_id
870: and defined_balance_id is null;
871:
872: /* New Query to get the Payee_type, Payee_id

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

996: lv_payroll_actid NUMBER;
997: lv_void_date DATE;
998: lv_payment_status VARCHAR2(10);
999:
1000: ln_defined_balance_id pay_org_payment_methods_f.defined_balance_id%TYPE; /* BUG: 5383895 added */
1001:
1002: BEGIN
1003: hr_utility.set_location(gv_package_name || '.payment_extract', 10);
1004: /* hr_utility.trace_on(null, 'ORACLE'); */