DBA Data[Home] [Help]

APPS.PA_BUDGET_WF dependencies on PA_EMPLOYEES

Line 524: , pa_employees e

520: SELECT f.user_id
521: , f.user_name
522: , e.first_name||' '||e.last_name
523: FROM fnd_user f
524: , pa_employees e
525: WHERE f.employee_id = p_baseliner_id
526: AND f.employee_id = e.person_id
527: AND TRUNC(SYSDATE) BETWEEN f.start_date AND nvl(f.end_date, TRUNC(SYSDATE)+1); --Added : 7688624
528:

Line 1194: , pa_employees e

1190: IS
1191: SELECT f.user_name
1192: ,e.first_name||' '||e.last_name
1193: FROM fnd_user f
1194: , pa_employees e
1195: WHERE f.user_id = p_baseliner_id
1196: AND f.employee_id = e.person_id
1197: AND TRUNC(SYSDATE) BETWEEN f.start_date AND nvl(f.end_date, TRUNC(SYSDATE)+1); --Added : Bug #14005015
1198: