APPS.AMS_GEN_APPROVAL_PVT dependencies on AMS_JTF_RS_EMP_V

Line 29: FROM ams_jtf_rs_emp_v

25: l_id NUMBER ;
26: l_user NUMBER;
27: CURSOR c_resource IS
28: SELECT user_id user_id
29: FROM ams_jtf_rs_emp_v
30: WHERE resource_id = p_user ;
31:
32: BEGIN
33: OPEN c_resource ;

Line 104: FROM ams_jtf_rs_emp_v

100: x_return_status OUT NOCOPY VARCHAR2)
101: IS
102: CURSOR c_resource IS
103: SELECT employee_id source_id
104: FROM ams_jtf_rs_emp_v
105: WHERE resource_id = p_user_id ;
106: l_person_id number;
107: BEGIN
108: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 146: FROM fnd_user f, ams_jtf_rs_emp_v r

142: l_territory VARCHAR2(30);
143:
144: CURSOR c_res_details(p_user_name IN VARCHAR2) IS
145: SELECT r.resource_id
146: FROM fnd_user f, ams_jtf_rs_emp_v r
147: WHERE r.user_id = f.user_id
148: AND f.user_name = p_user_name;
149:
150: BEGIN

Line 916: FROM ams_jtf_rs_emp_v

912: l_appr_hist_rec AMS_Appr_Hist_Pvt.Appr_Hist_Rec_Type;
913:
914: CURSOR c_resource IS
915: SELECT resource_id ,employee_id source_id,full_name resource_name
916: FROM ams_jtf_rs_emp_v
917: WHERE user_id = x_resource_id ;
918: BEGIN
919: FND_MSG_PUB.initialize();
920: