APPS.AMS_GEN_APPROVAL_PVT dependencies on AMS_JTF_RS_EMP_V

Line 27: FROM ams_jtf_rs_emp_v

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

Line 102: FROM ams_jtf_rs_emp_v

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

Line 144: FROM fnd_user f, ams_jtf_rs_emp_v r

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

Line 803: FROM ams_jtf_rs_emp_v

799: l_appr_hist_rec AMS_Appr_Hist_Pvt.Appr_Hist_Rec_Type;
800:
801: CURSOR c_resource IS
802: SELECT resource_id ,employee_id source_id,full_name resource_name
803: FROM ams_jtf_rs_emp_v
804: WHERE user_id = x_resource_id ;
805: BEGIN
806: FND_MSG_PUB.initialize();
807: