DBA Data[Home] [Help]

APPS.PAY_US_NACHA_TAPE dependencies on HR_ORGANIZATION_INFORMATION

Line 1525: hr_organization_units hou, hr_organization_information hoi,

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
1529: AND opm.org_payment_method_id = p_org_payment_method_id

Line 1584: pay_assignment_actions paa, hr_organization_information hoi

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
1588: AND ppa.payment_type_id = opm.payment_type_id