DBA Data[Home] [Help]

APPS.PJI_PMV_ENGINE dependencies on FND_USER

Line 1244: fnd_user fnd,

1240: SELECT sub_organization_id,
1241: org.name
1242: FROM pji_org_denorm orgd,
1243: hr_all_organization_units_tl org,
1244: fnd_user fnd,
1245: per_all_assignments_f per
1246: WHERE org.language = USERENV('LANG')
1247: AND fnd.user_id=l_user_id
1248: AND fnd.employee_id=per.person_id

Line 1247: AND fnd.user_id=l_user_id

1243: hr_all_organization_units_tl org,
1244: fnd_user fnd,
1245: per_all_assignments_f per
1246: WHERE org.language = USERENV('LANG')
1247: AND fnd.user_id=l_user_id
1248: AND fnd.employee_id=per.person_id
1249: AND per.primary_flag='Y'
1250: AND (SYSDATE BETWEEN per.effective_start_Date AND NVL(per.effective_end_date, SYSDATE + 1))
1251: AND orgd.sub_organization_id = org.organization_id