eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_PRE_PAY dependencies on PAY_ORG_PAYMENT_METHODS

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 1012: pay_org_payment_methods_f opm,

1008: pay_balance_types pbt,
1009: pay_defined_balances pdb,
1010: pay_payment_types ppt,
1011: pay_org_pay_method_usages_f pmu,
1012: pay_org_payment_methods_f opm,
1013: pay_payroll_actions ppa
1014: where ppa.payroll_action_id = payroll_action
1015: and ppa.payroll_id = pmu.payroll_id
1016: and ppa.payroll_id = pp.payroll_id

Line 1291: l_org_method_id pay_org_payment_methods.org_payment_method_id%TYPE;

1287: exchange_rate number;
1288: leg_code varchar2(150);
1289: prenote_default varchar2(1);
1290: found boolean;
1291: l_org_method_id pay_org_payment_methods.org_payment_method_id%TYPE;
1292: --
1293: begin
1294: --
1295: hr_utility.trace('Enter pay_per_payment_methods');

Line 1522: pay_org_payment_methods_f opm,

1518: ppt.pre_validation_required validation_required,
1519: ppt.validation_value validation_value,
1520: opm.external_account_id external_account_id
1521: from pay_payment_types ppt,
1522: pay_org_payment_methods_f opm,
1523: pay_run_type_org_methods_f rtom,
1524: pay_org_pay_method_usages_f opmu,
1525: pay_payroll_actions ppa,
1526: pay_assignment_actions paa

Line 1563: pay_org_payment_methods_f opm,

1559: ppt.validation_value validation_value,
1560: opm.external_account_id external_account_id
1561: from pay_external_accounts pea,
1562: pay_payment_types ppt,
1563: pay_org_payment_methods_f opm,
1564: pay_personal_payment_methods_f ppm,
1565: pay_assignment_actions act
1566: where act.assignment_action_id=p_assignment_action
1567: and ppm.assignment_id = act.assignment_id

Line 1601: l_org_method_id pay_org_payment_methods.org_payment_method_id%TYPE;

1597: assign_id number;
1598: leg_code varchar2(150);
1599: prenote_default varchar2(1);
1600: found boolean;
1601: l_org_method_id pay_org_payment_methods.org_payment_method_id%TYPE;
1602: got_payment_amount boolean;
1603: begin
1604: --
1605: hr_utility.trace('Enter pay_run_type_methods');

Line 2472: pay_org_payment_methods_f opm,

2468: from pay_run_results prr,
2469: pay_element_entries_f pee,
2470: pay_personal_payment_methods_f ppm,
2471: pay_external_accounts pea,
2472: pay_org_payment_methods_f opm,
2473: pay_payment_types ppt,
2474: pay_assignment_actions paa,
2475: pay_payroll_actions ppa
2476: where prr.run_result_id = p_run_results

Line 2653: from pay_org_payment_methods_f opm1

2649: -- Also currency needs to be the same.
2650: --
2651: select count(*)
2652: into l_paytype
2653: from pay_org_payment_methods_f opm1
2654: ,pay_org_payment_methods_f opm2
2655: where opm1.org_payment_method_id = p_org_meth
2656: and opm2.org_payment_method_id = l_org_method_id
2657: and opm1.payment_type_id = opm2.payment_type_id

Line 2654: ,pay_org_payment_methods_f opm2

2650: --
2651: select count(*)
2652: into l_paytype
2653: from pay_org_payment_methods_f opm1
2654: ,pay_org_payment_methods_f opm2
2655: where opm1.org_payment_method_id = p_org_meth
2656: and opm2.org_payment_method_id = l_org_method_id
2657: and opm1.payment_type_id = opm2.payment_type_id
2658: and opm1.currency_code = opm2.currency_code

Line 2668: from pay_org_payment_methods_f opm

2664: -- Check that the new payment method does not have a null bank account
2665: --
2666: select count(*)
2667: into l_ext_acc
2668: from pay_org_payment_methods_f opm
2669: where opm.org_payment_method_id = l_org_method_id
2670: and opm.external_account_id is not null
2671: and p_effective_date between opm.effective_start_date
2672: and opm.effective_end_date;

Line 2734: pay_org_payment_methods_f popm,

2730: ppa.business_group_id)) payment_date
2731: from
2732: pay_external_accounts pea,
2733: pay_payment_types ppt,
2734: pay_org_payment_methods_f popm,
2735: pay_org_payment_methods_f popm_par,
2736: pay_org_pay_method_usages_f popmu,
2737: pay_assignment_actions paa,
2738: pay_payroll_actions ppa

Line 2735: pay_org_payment_methods_f popm_par,

2731: from
2732: pay_external_accounts pea,
2733: pay_payment_types ppt,
2734: pay_org_payment_methods_f popm,
2735: pay_org_payment_methods_f popm_par,
2736: pay_org_pay_method_usages_f popmu,
2737: pay_assignment_actions paa,
2738: pay_payroll_actions ppa
2739: where paa.assignment_action_id = p_asg_action