DBA Data[Home] [Help]

APPS.PV_AME_API_W dependencies on FND_USER

Line 594: FOR x IN (SELECT employee_id,user_name FROM fnd_user WHERE user_id = p_forwardee_user_id

590: CLOSE lc_get_approver_details;
591:
592: IF p_response = AME_UTIL.forwardStatus THEN -- FORWARD
593:
594: FOR x IN (SELECT employee_id,user_name FROM fnd_user WHERE user_id = p_forwardee_user_id
595: AND (end_date IS NULL OR end_date > sysdate-1))
596: LOOP
597: l_forwardee.orig_system_id := x.employee_id;
598: l_forwardee.name := x.user_name;

Line 1271: FROM fnd_user A , pv_ge_temp_approvers appr

1267: RETURN BOOLEAN IS
1268:
1269: CURSOR c_user(pc_person_id NUMBER) IS
1270: SELECT 'Y'
1271: FROM fnd_user A , pv_ge_temp_approvers appr
1272: WHERE A.employee_id = pc_person_id
1273: AND ( A.end_date IS NULL OR A.end_date > sysdate-1)
1274: AND A.user_id = appr.approver_id
1275: AND appr.approval_status_code = 'PENDING_APPROVAL'

Line 1516: FOR x IN (SELECT A.user_id FROM fnd_user A, jtf_rs_resource_extns B

1512: x_user_id_exists := 'N';
1513:
1514: IF (l_orig_system = 'PER') THEN
1515:
1516: FOR x IN (SELECT A.user_id FROM fnd_user A, jtf_rs_resource_extns B
1517: WHERE employee_id = currApprRec.orig_system_id
1518: AND A.user_id = B.user_id
1519: AND ( A.end_date IS NULL OR A.end_date > sysdate-1) )
1520: LOOP