DBA Data[Home] [Help]

APPS.PAY_KR_NONSTAT_SPAY_EFILE dependencies on HR_ORGANIZATION_UNITS

Line 81: ,hr_organization_units hou

77: cursor c_business_place_count
78: is
79: select count(distinct hoi.org_information2||ihoi.org_information9) bp_count
80: from hr_organization_information hoi
81: ,hr_organization_units hou
82: ,hr_organization_units phou
83: ,hr_organization_information phoi
84: ,hr_organization_information ihoi
85: where hou.organization_id = hoi.organization_id

Line 82: ,hr_organization_units phou

78: is
79: select count(distinct hoi.org_information2||ihoi.org_information9) bp_count
80: from hr_organization_information hoi
81: ,hr_organization_units hou
82: ,hr_organization_units phou
83: ,hr_organization_information phoi
84: ,hr_organization_information ihoi
85: where hou.organization_id = hoi.organization_id
86: and hoi.org_information_context = 'KR_BUSINESS_PLACE_REGISTRATION'