DBA Data[Home] [Help]

APPS.AMS_WFTRIG_PVT dependencies on AMS_JTF_RS_EMP_V

Line 94: FROM ams_jtf_rs_emp_v

90: WHERE event_offer_id = p_activity_id ;
91:
92: CURSOR c_emp_dtl(l_res_id IN NUMBER) IS
93: SELECT employee_id
94: FROM ams_jtf_rs_emp_v
95: WHERE resource_id = l_res_id ;
96:
97: l_user_id NUMBER ;
98: l_emp_id NUMBER ;

Line 2028: FROM ams_jtf_rs_emp_v

2024: x_return_status OUT NOCOPY VARCHAR2)
2025: IS
2026: CURSOR c_resource IS
2027: SELECT employee_id source_id
2028: FROM ams_jtf_rs_emp_v
2029: WHERE resource_id = p_user_id ;
2030: l_person_id number;
2031: BEGIN
2032: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3355: FROM ams_jtf_rs_emp_v

3351:
3352: -- anchaudh defining cursor for setting item owner along with bug fix for bug# 3799053
3353: CURSOR c_emp_dtl(l_res_id IN NUMBER) IS
3354: SELECT employee_id
3355: FROM ams_jtf_rs_emp_v
3356: WHERE resource_id = l_res_id ;
3357:
3358: CURSOR c_trig_det IS
3359: SELECT *