APPS.GHR_NON_SF52_EXTRA_INFO dependencies on PAY_ELEMENT_TYPES_F

Line 1054: l_new_element_name pay_element_types_f.element_name%type;

1050: l_pa_request_id ghr_pa_requests.pa_request_id%type;
1051: l_effective_date ghr_pa_requests.effective_date%type;
1052: l_start_date per_time_periods.start_date%type;
1053: l_family_code ghr_pa_requests.noa_family_code%type;
1054: l_new_element_name pay_element_types_f.element_name%type;
1055: l_bus_group_id per_all_people_f.business_group_id%type;
1056: l_fehb_exists BOOLEAN;
1057: l_tsp_exists BOOLEAN;
1058: l_health_plan pay_element_entry_values_f.screen_entry_value%type;

Line 1086: c_element_name pay_element_types_f.element_name%type,

1082: AND TO_CHAR(start_date,'YYYY') = c_year
1083: AND TO_CHAR(start_date,'MM') = c_month;
1084:
1085: CURSOR c_element_entry(c_assignment_id pay_element_entries_f.assignment_id%type,
1086: c_element_name pay_element_types_f.element_name%type,
1087: c_effective_date pay_element_entries_f.effective_start_date%type) IS
1088: SELECT 1
1089: FROM pay_element_entries_f ele
1090: WHERE ele.assignment_id = c_assignment_id

Line 1093: FROM pay_element_types_f elt

1089: FROM pay_element_entries_f ele
1090: WHERE ele.assignment_id = c_assignment_id
1091: AND c_effective_date BETWEEN ele.effective_start_date AND effective_end_date
1092: AND ele.element_type_id = (SELECT elt.element_type_id
1093: FROM pay_element_types_f elt
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,

Line 1097: CURSOR c_element_value (c_element_name pay_element_types_f.element_name%type,

1093: FROM pay_element_types_f elt
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,

Line 1111: FROM pay_element_types_f a,

1107: e.assignment_id assignment_id,
1108: e.object_version_number object_version_number,
1109: f.element_entry_value_id element_entry_value_id,
1110: f.screen_entry_value screen_entry_value
1111: FROM pay_element_types_f a,
1112: pay_input_values_f b,
1113: pay_element_entries_f e,
1114: pay_element_entry_values_f f
1115: WHERE a.element_type_id = b.element_type_id AND