DBA Data[Home] [Help]

APPS.OTA_LEARNER_ACCESS_UTIL dependencies on PER_PERSON_TYPES

Line 452: ,per_person_types ppt

448: p_position_id ota_event_associations.position_id%type,
449: p_as_of date) is
450: select asg.assignment_id
451: from per_all_assignments_f asg
452: ,per_person_types ppt
453: ,per_all_people_f perp
454: ,per_person_type_usages_f ptu
455: where asg.person_id = p_person_id
456: and asg.person_id = perp.person_id

Line 505: ,per_person_types ppt

501: x.org_structure_version_id = currv.org_structure_version_id and
502: x.organization_id = p_organization_id and
503: x.sub_org_relative_level > 0
504: ) orgs
505: ,per_person_types ppt
506: ,per_all_people_f perp
507: ,per_person_type_usages_f ptu
508: where asg.person_id = p_person_id
509: and asg.person_id = perp.person_id