DBA Data[Home] [Help]

APPS.HR_H2PI_MAPPING_SETUP dependencies on HR_H2PI_BG_AND_GRE_V

Line 79: FROM hr_h2pi_bg_and_gre_v org

75: WHERE org.client_id = l_from_client_id) v1,
76: ( SELECT distinct org.organization_id to_org_id,
77: org.business_group_id,
78: org.name
79: FROM hr_h2pi_bg_and_gre_v org
80: WHERE org.business_group_id = l_to_business_group_id) v2
81: WHERE v1.name = v2.name
82: AND NOT EXISTS (SELECT 1
83: FROM hr_h2pi_id_mapping map

Line 111: FROM hr_h2pi_bg_and_gre_v org,

107: ( SELECT distinct ogi.org_information_id to_org_info_id,
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