DBA Data[Home] [Help]

APPS.GHR_MRE_PKG dependencies on PER_PERSON_TYPES

Line 99: per_person_types ppt,

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

Line 137: per_person_types ppt,

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