DBA Data[Home] [Help]

APPS.PAY_ZA_EFT_RECONCILIATION dependencies on HR_ORGANIZATION_INFORMATION

Line 73: hr_organization_information hoi,

69: CURSOR inst_code_and_type IS
70: select substr(hoi.org_information1, 1, 80),
71: substr(hoi.org_information2, 1, 80)
72: from pay_payroll_actions ppa,
73: hr_organization_information hoi,
74: hr_organization_units hou
75: where ppa.payroll_action_id = p_payroll_action_id
76: and hou.organization_id = ppa.business_group_id
77: and hoi.organization_id = hou.organization_id