DBA Data[Home] [Help]

APPS.GHR_MTO_PKG dependencies on PER_PERSON_TYPES

Line 222: per_person_types ppt,

218: paf.business_group_id BUSINESS_GROUP_ID,
219: punits.name ORGANIZATION_NAME
220: from per_assignments_f paf,
221: per_people_f ppf,
222: per_person_types ppt,
223: per_organization_units punits
224: -- VSM added nvl( .. to the start... clause
225: -- enhancement in selection criteria as org_id can be be null [Masscrit.doc]
226: where (paf.organization_id = nvl(p_org_id, paf.organization_id)

Line 259: per_person_types ppt,

255: paf.business_group_id BUSINESS_GROUP_ID,
256: punits.name ORGANIZATION_NAME
257: from per_assignments_f paf,
258: per_people_f ppf,
259: per_person_types ppt,
260: per_organization_units punits
261: where (paf.position_id = nvl(p_org_id,paf.position_id)
262: and
263: org_pos_fl = 'P')