DBA Data[Home] [Help]

APPS.OTA_LEARNER_ENROLL_SS dependencies on PER_PHONES

Line 111: , per_phones pph

107: ,per_person_type_usages_f ptu
108: -- ,per_addresses ad
109: ,hr_locations_all loc
110: ,hr_all_organization_units org
111: , per_phones pph
112: , per_phones pfax
113: WHERE pp.person_id = p_person_id
114: AND trunc(sysdate) BETWEEN pp.effective_start_date AND pp.effective_end_date
115: and asg.person_id = pp.person_id

Line 112: , per_phones pfax

108: -- ,per_addresses ad
109: ,hr_locations_all loc
110: ,hr_all_organization_units org
111: , per_phones pph
112: , per_phones pfax
113: WHERE pp.person_id = p_person_id
114: AND trunc(sysdate) BETWEEN pp.effective_start_date AND pp.effective_end_date
115: and asg.person_id = pp.person_id
116: --Modified for bug#5579345