APPS.HR_PRE_PAY dependencies on PAY_ORG_PAYMENT_METHODS_F

Line 88: pay_org_payment_methods_f opm,

84: opm.external_account_id external_account_id
85: -- from hr_lookups hlu,
86: from pay_external_accounts pea,
87: pay_payment_types ppt,
88: pay_org_payment_methods_f opm,
89: pay_personal_payment_methods_f ppm
90: where ppm.assignment_id = p_assignment
91: and ppm.run_type_id is null
92: and ppm.org_payment_method_id = opm.org_payment_method_id

Line 627: from pay_org_payment_methods_f opm,

623: -- Now derive override org payment method when external account id is null.
624: --
625: select opm.external_account_id
626: into l_ext_acc
627: from pay_org_payment_methods_f opm,
628: pay_assignment_actions paa,
629: pay_payroll_actions ppa
630: where paa.assignment_action_id = action_id
631: and ppa.payroll_action_id = paa.payroll_action_id

Line 900: pay_org_payment_methods_f opm,

896: pay_balance_types pbt,
897: pay_defined_balances pdb,
898: pay_payment_types ppt,
899: pay_all_payrolls_f pp,
900: pay_org_payment_methods_f opm,
901: pay_payroll_actions ppa
902: where ppa.payroll_action_id = payroll_action
903: and ppa.payroll_id = pp.payroll_id
904: and pp.default_payment_method_id = opm.org_payment_method_id

Line 1007: pay_org_payment_methods_f opm,

1003: pay_balance_types pbt,
1004: pay_defined_balances pdb,
1005: pay_payment_types ppt,
1006: pay_org_pay_method_usages_f pmu,
1007: pay_org_payment_methods_f opm,
1008: pay_payroll_actions ppa
1009: where ppa.payroll_action_id = payroll_action
1010: and ppa.payroll_id = pmu.payroll_id
1011: and ppa.payroll_id = pp.payroll_id

Line 1517: pay_org_payment_methods_f opm,

1513: ppt.pre_validation_required validation_required,
1514: ppt.validation_value validation_value,
1515: opm.external_account_id external_account_id
1516: from pay_payment_types ppt,
1517: pay_org_payment_methods_f opm,
1518: pay_run_type_org_methods_f rtom,
1519: pay_org_pay_method_usages_f opmu,
1520: pay_payroll_actions ppa,
1521: pay_assignment_actions paa

Line 1558: pay_org_payment_methods_f opm,

1554: ppt.validation_value validation_value,
1555: opm.external_account_id external_account_id
1556: from pay_external_accounts pea,
1557: pay_payment_types ppt,
1558: pay_org_payment_methods_f opm,
1559: pay_personal_payment_methods_f ppm,
1560: pay_assignment_actions act
1561: where act.assignment_action_id=p_assignment_action
1562: and ppm.assignment_id = act.assignment_id

Line 2447: pay_org_payment_methods_f opm,

2443: from pay_run_results prr,
2444: pay_element_entries_f pee,
2445: pay_personal_payment_methods_f ppm,
2446: pay_external_accounts pea,
2447: pay_org_payment_methods_f opm,
2448: pay_payment_types ppt,
2449: pay_assignment_actions paa,
2450: pay_payroll_actions ppa
2451: where prr.run_result_id = p_run_results

Line 2617: from pay_org_payment_methods_f opm1

2613: -- Also currency needs to be the same.
2614: --
2615: select count(*)
2616: into l_paytype
2617: from pay_org_payment_methods_f opm1
2618: ,pay_org_payment_methods_f opm2
2619: where opm1.org_payment_method_id = p_org_meth
2620: and opm2.org_payment_method_id = l_org_method_id
2621: and opm1.payment_type_id = opm2.payment_type_id

Line 2618: ,pay_org_payment_methods_f opm2

2614: --
2615: select count(*)
2616: into l_paytype
2617: from pay_org_payment_methods_f opm1
2618: ,pay_org_payment_methods_f opm2
2619: where opm1.org_payment_method_id = p_org_meth
2620: and opm2.org_payment_method_id = l_org_method_id
2621: and opm1.payment_type_id = opm2.payment_type_id
2622: and opm1.currency_code = opm2.currency_code

Line 2632: from pay_org_payment_methods_f opm

2628: -- Check that the new payment method does not have a null bank account
2629: --
2630: select count(*)
2631: into l_ext_acc
2632: from pay_org_payment_methods_f opm
2633: where opm.org_payment_method_id = l_org_method_id
2634: and opm.external_account_id is not null
2635: and p_effective_date between opm.effective_start_date
2636: and opm.effective_end_date;

Line 2698: pay_org_payment_methods_f popm,

2694: ppa.business_group_id)) payment_date
2695: from
2696: pay_external_accounts pea,
2697: pay_payment_types ppt,
2698: pay_org_payment_methods_f popm,
2699: pay_org_payment_methods_f popm_par,
2700: pay_org_pay_method_usages_f popmu,
2701: pay_assignment_actions paa,
2702: pay_payroll_actions ppa

Line 2699: pay_org_payment_methods_f popm_par,

2695: from
2696: pay_external_accounts pea,
2697: pay_payment_types ppt,
2698: pay_org_payment_methods_f popm,
2699: pay_org_payment_methods_f popm_par,
2700: pay_org_pay_method_usages_f popmu,
2701: pay_assignment_actions paa,
2702: pay_payroll_actions ppa
2703: where paa.assignment_action_id = p_asg_action