DBA Data[Home] [Help]

APPS.PA_BUDGET_WF dependencies on FND_USER

Line 523: FROM fnd_user f

519: IS
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

Line 1180: FROM fnd_user f

1176:
1177: CURSOR l_get_baseliner_userid_csr( p_item_key VARCHAR2)
1178: IS
1179: SELECT f.user_id
1180: FROM fnd_user f
1181: WHERE f.user_name = (select assigned_user FROM (SELECT assigned_user
1182: FROM wf_item_activity_statuses
1183: WHERE item_key = p_item_key
1184: AND activity_result_code = 'APPROVED'

Line 1193: FROM fnd_user f

1189: CURSOR l_baseliner_user_details_csr( p_baseliner_id NUMBER )
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