DBA Data[Home] [Help]

APPS.GHR_MTO_PKG dependencies on PER_PERSON_TYPES

Line 227: per_person_types ppt,

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

Line 270: per_person_types ppt,

266: paf.business_group_id BUSINESS_GROUP_ID,
267: punits.name ORGANIZATION_NAME
268: from per_assignments_f paf,
269: per_people_f ppf,
270: per_person_types ppt,
271: per_organization_units punits
272: where (paf.position_id = nvl(p_org_id,paf.position_id)
273: and
274: org_pos_fl = 'P')