APPS.GHR_NON_SF52_EXTRA_INFO dependencies on PER_ALL_ASSIGNMENTS_F

Line 27: FROM per_all_assignments_f

23:
24: --Begin Bug 5923620
25: CURSOR GET_ASSIGNEMNT_ID IS
26: SELECT assignment_id
27: FROM per_all_assignments_f
28: WHERE person_id = p_person_id
29: AND p_effective_date between effective_start_date AND effective_end_date;
30:
31: l_assignment_id per_assignments_f.assignment_id%type;

Line 954: FROM per_all_assignments_f

950: Following cursor has been added to fetch assignment id when p_assignment_id is null. */
951:
952: CURSOR GET_ASSIGNEMNT_ID IS
953: SELECT assignment_id
954: FROM per_all_assignments_f
955: WHERE person_id = p_person_id
956: AND p_effective_date between effective_start_date AND effective_end_date;
957: /*End Bug -6129752 */
958: -- populate rei_information with appt_info

Line 1240: c_assignment_id per_all_assignments_f.assignment_id%type,

1236: WHERE element_name = c_element_name
1237: AND c_effective_date BETWEEN elt.effective_start_date AND elt.effective_end_date);
1238:
1239: CURSOR c_element_value (c_element_name pay_element_types_f.element_name%type,
1240: c_assignment_id per_all_assignments_f.assignment_id%type,
1241: c_effective_date pay_element_entries_f.effective_start_date%type
1242: ) is
1243: SELECT a.element_name element_name,
1244: b.NAME ipv_name,