DBA Data[Home] [Help]

APPS.PA_SECURITY_PVT dependencies on PER_ALL_ASSIGNMENTS_F

Line 859: FROM per_all_assignments_f -- Bug 4359282: Changed from per_assignments_f to all

855: --the first assignment available from sysdate
856: -- Bug 2911451 - Included condition for Assignment_type ='E'
857: CURSOR c_org_id IS
858: SELECT organization_id
859: FROM per_all_assignments_f -- Bug 4359282: Changed from per_assignments_f to all
860: WHERE person_id=v_person_id
861: AND TRUNC(effective_start_date)<=TRUNC(NVL(p_start_date, effective_start_date))
862: AND TRUNC(NVL(p_start_date,SYSDATE))<=TRUNC(effective_end_date)
863: AND primary_flag='Y'