DBA Data[Home] [Help]

APPS.PA_SECURITY_PVT dependencies on PER_ALL_ASSIGNMENTS_F

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

844: --the first assignment available from sysdate
845: -- Bug 2911451 - Included condition for Assignment_type ='E'
846: CURSOR c_org_id IS
847: SELECT organization_id
848: FROM per_all_assignments_f -- Bug 4359282: Changed from per_assignments_f to all
849: WHERE person_id=v_person_id
850: AND TRUNC(effective_start_date)<=TRUNC(NVL(p_start_date, effective_start_date))
851: AND TRUNC(NVL(p_start_date,SYSDATE))<=TRUNC(effective_end_date)
852: AND primary_flag='Y'