DBA Data[Home] [Help]

APPS.GHR_MRE_PKG dependencies on PER_PERSON_TYPES

Line 101: per_person_types ppt,

97: paf.business_group_id BUSINESS_GROUP_ID,
98: punits.name ORGANIZATION_NAME
99: from per_assignments_f paf,
100: per_people_f ppf,
101: per_person_types ppt,
102: per_organization_units punits
103: -- VSM added nvl( .. to the start... clause
104: -- enhancement in SELECTion criteria as org_id can be be null [Masscrit.doc]
105: WHERE (paf.organization_id = nvl(p_org_pos_id, paf.organization_id)

Line 141: per_person_types ppt,

137: paf.business_group_id BUSINESS_GROUP_ID,
138: punits.name ORGANIZATION_NAME
139: from per_assignments_f paf,
140: per_people_f ppf,
141: per_person_types ppt,
142: per_organization_units punits
143: WHERE (paf.position_id = nvl(p_org_pos_id,paf.position_id)
144: and
145: org_pos_fl = 'P')