DBA Data[Home] [Help]

APPS.PAY_US_NACHA_IAT_TAPE dependencies on HR_ORGANIZATION_INFORMATION

Line 171: hr_organization_information hroinf

167: opm.pmeth_information6
168: FROM pay_payroll_actions ppa , -- Add here to allow join directly to ORG_PAYMENT_METHOD_ID
169: pay_org_payment_methods_f opm,
170: hr_organization_units hrorgu ,
171: hr_organization_information hroinf
172: WHERE ppa.payroll_action_id = p_payroll_action_id -- New clause to allow primary key access
173: AND ppa.org_payment_method_id = opm.org_payment_method_id -- join PPA to OPM to narrow to one method
174: AND p_effective_date BETWEEN opm.effective_start_date AND opm.effective_end_date
175: AND hrorgu.business_group_id = p_business_group_id