APPS.PJI_PMV_UTIL dependencies on PER_ALL_ASSIGNMENTS_F
Line 48: per_all_assignments_f per
44:
45: SELECT per.organization_id
46: INTO l_top_organization_id
47: FROM fnd_user fndu, 48: per_all_assignments_f per 49: WHERE fndu.user_id=l_user_id
50: AND fndu.employee_id=per.person_id
51: AND per.primary_flag='Y'
52: AND (SYSDATE BETWEEN per.effective_start_Date AND NVL(per.effective_end_date, SYSDATE + 1));