DBA Data[Home] [Help]

APPS.PJI_PMV_UTIL dependencies on PER_ALL_ASSIGNMENTS_F

Line 964: per_all_assignments_f per

960:
961: SELECT per.organization_id
962: INTO l_top_organization_id
963: FROM fnd_user fndu,
964: per_all_assignments_f per
965: WHERE fndu.user_id=l_user_id
966: AND fndu.employee_id=per.person_id
967: AND per.primary_flag='Y'
968: AND (SYSDATE BETWEEN per.effective_start_Date AND NVL(per.effective_end_date, SYSDATE + 1));