APPS.JTF_RS_IMP_RES_PVT dependencies on PER_ALL_ASSIGNMENTS_F

Line 46: l_assignment_type per_all_assignments_f.assignment_type%TYPE;

42: l_resource_number jtf_rs_resource_extns.resource_number%TYPE ;
43: l_role_relate_id jtf_rs_role_relations.role_relate_id%TYPE;
44:
45: l_source_number jtf_rs_resource_extns.source_number%TYPE;
46: l_assignment_type per_all_assignments_f.assignment_type%TYPE;
47:
48: -- fetching the role_type_code in this cursor also so that if salesrep is not created then
49: -- do not create roles of type SALES_COMP -- bug 3579147
50: -- new cursor added (repuri 04/07/03)

Line 185: FROM PER_all_assignments_f

181: -- Cursor to get the Effective Start Date, for a given Job Assignment of an Employee.
182:
183: CURSOR c_get_asg_start_date (l_job_id IN NUMBER, l_person_id IN NUMBER, l_assignment_id NUMBER, l_assignment_type IN VARCHAR2) IS
184: SELECT EFFECTIVE_START_DATE
185: FROM PER_all_assignments_f
186: WHERE person_id = l_person_id
187: AND ASSIGNMENT_TYPE = l_assignment_type
188: AND PRIMARY_FLAG = 'Y'
189: AND job_id = l_job_id