DBA Data[Home] [Help]

APPS.AS_ACCESS_PVT dependencies on PER_ALL_PEOPLE_F

Line 862: FROM per_all_people_f per,

858: IS
859:
860: Cursor C_Check_Assign_Person (X_person_id NUMBER) IS
861: SELECT 'X'
862: FROM per_all_people_f per,
863: jtf_rs_resource_extns res
864: WHERE per.person_id = X_person_id
865: AND TRUNC(SYSDATE) BETWEEN per.effective_start_date
866: AND per.effective_end_date