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.PAY_US_NACHA_TAPE dependencies on PAY_ORG_PAYMENT_METHODS_F

Line 1245: pay_org_payment_methods_f opm

1241: g_legislative_parameters,
1242: g_csr_org_pay_third_party,
1243: g_payroll_id
1244: from pay_payroll_actions ppa,
1245: pay_org_payment_methods_f opm
1246: where ppa.payroll_action_id = g_payroll_action_id
1247: and opm.ORG_PAYMENT_METHOD_ID = ppa.org_payment_method_id
1248: and ppa.effective_date between opm.EFFECTIVE_START_DATE
1249: and opm.EFFECTIVE_END_DATE;

Line 1512: FROM pay_payroll_actions ppa, pay_org_payment_methods_f opm, pay_assignment_actions paa

1508:
1509: CURSOR csr_get_transact_date IS
1510: SELECT to_char(ppa.effective_date,'YYYY/MM/DD') effective_date,
1511: to_char(ppa.overriding_dd_date,'YYYY/MM/DD') overriding_dd_date
1512: FROM pay_payroll_actions ppa, pay_org_payment_methods_f opm, pay_assignment_actions paa
1513: WHERE ppa.payroll_action_id = p_payroll_action_id
1514: AND opm.org_payment_method_id = ppa.org_payment_method_id
1515: AND opm.org_payment_method_id = p_org_payment_method_id
1516: AND ppa.effective_date BETWEEN opm.effective_start_date AND opm.effective_end_date

Line 1524: FROM pay_pre_payments ppp, pay_org_payment_methods_f opm,

1520: lr_transact_date_rec csr_get_transact_date%ROWTYPE;
1521:
1522: CURSOR csr_get_batch_no IS
1523: SELECT ppp.org_payment_method_id, hou.organization_id, paa.assignment_action_id
1524: FROM pay_pre_payments ppp, pay_org_payment_methods_f opm,
1525: hr_organization_units hou, hr_organization_information hoi,
1526: pay_payroll_actions ppa, pay_assignment_actions paa
1527: WHERE opm.org_payment_method_id = ppp.org_payment_method_id
1528: AND opm.org_payment_method_id = ppa.org_payment_method_id

Line 1583: FROM pay_org_payment_methods_f opm, pay_payroll_actions ppa,

1579: -- added opm.pmeth_information17 for 12848280
1580: CURSOR csr_get_conc_ident_values IS
1581: SELECT opm.pmeth_information3, nvl(opm.pmeth_information17,
1582: hoi.org_information4) org_information4
1583: FROM pay_org_payment_methods_f opm, pay_payroll_actions ppa,
1584: pay_assignment_actions paa, hr_organization_information hoi
1585: WHERE ppa.payroll_action_id = p_payroll_action_id
1586: AND ppa.effective_date BETWEEN opm.effective_start_date AND opm.effective_end_date
1587: AND ppa.org_payment_method_id = opm.org_payment_method_id