DBA Data[Home] [Help]

APPS.HR_H2PI_MAPPING_SETUP dependencies on HR_H2PI_ORGANIZATION_INFO

Line 103: hr_h2pi_organization_info ogi

99: org.business_group_id,
100: org.name org_name,
101: ogi.org_information_context org_info_name
102: FROM hr_h2pi_bg_and_gre org,
103: hr_h2pi_organization_info ogi
104: WHERE org.organization_id = ogi.organization_id
105: AND ogi.org_information_context <> 'CLASS'
106: AND org.client_id = l_from_client_id) v1,
107: ( SELECT distinct ogi.org_information_id to_org_info_id,

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