APPS.OTA_OFF_BUS dependencies on PER_ALL_PEOPLE_F

Line 871: FROM Per_all_people_f per

867: l_proc varchar2(72) := g_package||'check_owner_id';
868: CURSOR c_people
869: IS
870: SELECT null
871: FROM Per_all_people_f per
872: WHERE per.person_id = p_owner_id and
873: per.business_group_id = p_business_group_id and
874: NVL(start_date,TRUNC(SYSDATE)) between
875: effective_start_date and effective_end_date;

Line 879: FROM Per_all_people_f per

875: effective_start_date and effective_end_date;
876: CURSOR c_people_cross
877: IS
878: SELECT null
879: FROM Per_all_people_f per
880: WHERE per.person_id = p_owner_id and
881: NVL(start_date,TRUNC(SYSDATE)) between
882: effective_start_date and effective_end_date;
883: l_exist varchar2(1);