APPS.PV_AME_API_W dependencies on JTF_RS_RESOURCE_EXTNS

Line 56: SELECT source_name FROM jtf_rs_resource_extns WHERE user_id = pc_user_id;

52: FROM pv_referrals_b
53: WHERE referral_id = pc_referral_id;
54:
55: CURSOR lc_get_approver_name (pc_user_id NUMBER) IS
56: SELECT source_name FROM jtf_rs_resource_extns WHERE user_id = pc_user_id;
57:
58: CURSOR lc_prior_approvers IS
59: SELECT APPROVER_ID
60: FROM PV_GE_TEMP_APPROVERS

Line 360: FOR x in (SELECT source_name FROM jtf_rs_resource_extns B WHERE user_id = approverUserIds(apprCnt) )

356:
357: IF l_message_name IS NOT NULL THEN
358:
359: l_log_params_tbl.DELETE;
360: FOR x in (SELECT source_name FROM jtf_rs_resource_extns B WHERE user_id = approverUserIds(apprCnt) )
361: LOOP
362: l_log_params_tbl(1).param_value := x.source_name;
363: END LOOP;
364:

Line 505: select decode(category, 'EMPLOYEE', source_id, null), category, source_name, user_name from jtf_rs_resource_extns where user_id = pc_user_id;

501: and approver_id = pc_user_id
502: and approval_status_code IN ('PENDING_APPROVAL','PENDING_DEFAULT');
503:
504: cursor lc_get_approver_details (pc_user_id number) is
505: select decode(category, 'EMPLOYEE', source_id, null), category, source_name, user_name from jtf_rs_resource_extns where user_id = pc_user_id;
506:
507: cursor lc_return_reason IS
508: select return_reason_code from pv_referrals_b
509: where referral_id = p_referral_id;

Line 1095: FOR x in (SELECT source_name FROM jtf_rs_resource_extns B WHERE user_id = l_approval_list(apprCnt) )

1091:
1092: FOR apprCnt IN 1..l_approval_list.COUNT
1093: LOOP
1094:
1095: FOR x in (SELECT source_name FROM jtf_rs_resource_extns B WHERE user_id = l_approval_list(apprCnt) )
1096: LOOP
1097: l_log_params_tbl(1).param_value := x.source_name;
1098: END LOOP;
1099:

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