DBA Data[Home] [Help]

APPS.HR_H2PI_MAPPING_SETUP dependencies on HR_H2PI_ORGANIZATION_INFO_V

Line 112: hr_h2pi_organization_info_v ogi

108: org.business_group_id,
109: org.name org_name,
110: ogi.org_information_context org_info_name
111: FROM hr_h2pi_bg_and_gre_v org,
112: hr_h2pi_organization_info_v ogi
113: WHERE org.organization_id = ogi.organization_id
114: AND ogi.org_information_context <> 'CLASS'
115: AND org.business_group_id = l_to_business_group_id) v2
116: WHERE v1.org_name = v2.org_name