DBA Data[Home] [Help]

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));