APPS.GHR_NON_SF52_EXTRA_INFO dependencies on PER_ALL_ASSIGNMENTS_F

Line 19: FROM per_all_assignments_f

15:
16: --Begin Bug 5923620
17: CURSOR GET_ASSIGNEMNT_ID IS
18: SELECT assignment_id
19: FROM per_all_assignments_f
20: WHERE person_id = p_person_id
21: AND p_effective_date between effective_start_date AND effective_end_date;
22:
23: l_assignment_id per_assignments_f.assignment_id%type;

Line 876: FROM per_all_assignments_f

872: Following cursor has been added to fetch assignment id when p_assignment_id is null. */
873:
874: CURSOR GET_ASSIGNEMNT_ID IS
875: SELECT assignment_id
876: FROM per_all_assignments_f
877: WHERE person_id = p_person_id
878: AND p_effective_date between effective_start_date AND effective_end_date;
879: /*End Bug -6129752 */
880: -- populate rei_information with appt_info

Line 1098: c_assignment_id per_all_assignments_f.assignment_id%type,

1094: WHERE element_name = c_element_name
1095: AND c_effective_date BETWEEN elt.effective_start_date AND elt.effective_end_date);
1096:
1097: CURSOR c_element_value (c_element_name pay_element_types_f.element_name%type,
1098: c_assignment_id per_all_assignments_f.assignment_id%type,
1099: c_effective_date pay_element_entries_f.effective_start_date%type
1100: ) is
1101: SELECT a.element_name element_name,
1102: b.NAME ipv_name,