APPS.PQP_HROSS_INTEGRATION dependencies on PER_ASSIGNMENTS_F

Line 50: ,comment_id per_assignments_f.comment_id%TYPE

46: ,entries_changed_warning Varchar2(50)
47: ,tax_district_changed_warning Boolean
48: ,concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE
49: ,gsp_post_process_warning Varchar2(2000)
50: ,comment_id per_assignments_f.comment_id%TYPE
51: );
52:
53: TYPE t_Upd_Emp_Asg_Api IS RECORD
54: (cagr_grade_def_id per_all_assignments_f.cagr_grade_def_id%TYPE

Line 232: FROM per_assignments_f asg

228: ) IS
229: SELECT asg.assignment_id
230: ,asg.object_version_number
231: ,asg.vacancy_id
232: FROM per_assignments_f asg
233: ,per_assignment_status_types ast
234: WHERE asg.assignment_status_type_id = ast.assignment_status_type_id
235: AND asg.person_id = c_person_id
236: AND asg.business_group_id = c_business_group_id

Line 253: FROM per_assignments_f asg

249: ) IS
250: SELECT asg.assignment_id
251: ,asg.object_version_number
252: ,asg.vacancy_id
253: FROM per_assignments_f asg
254: ,per_assignment_status_types ast
255: WHERE asg.assignment_status_type_id = ast.assignment_status_type_id
256: AND asg.person_id = c_person_id
257: AND asg.business_group_id = c_business_group_id

Line 5557: FROM per_people_f ppf, per_assignments_f paf

5553: CURSOR get_dup_asg_id (c_dup_per_id Varchar2
5554: ,c_business_group_id Varchar2
5555: ,c_eff_date Date) IS
5556: SELECT paf.assignment_id
5557: FROM per_people_f ppf, per_assignments_f paf
5558: WHERE paf.person_id = c_dup_per_id
5559: AND paf.person_id = ppf.person_id
5560: AND paf.business_group_id = c_business_group_id
5561: AND paf.business_group_id = ppf.business_group_id