APPS.GHR_NON_SF52_EXTRA_INFO dependencies on PAY_ELEMENT_TYPES_F

Line 1192: l_new_element_name pay_element_types_f.element_name%type;

1188: l_pa_request_id ghr_pa_requests.pa_request_id%type;
1189: l_effective_date ghr_pa_requests.effective_date%type;
1190: l_start_date per_time_periods.start_date%type;
1191: l_family_code ghr_pa_requests.noa_family_code%type;
1192: l_new_element_name pay_element_types_f.element_name%type;
1193: l_bus_group_id per_all_people_f.business_group_id%type;
1194: l_fehb_exists BOOLEAN;
1195: l_tsp_exists BOOLEAN;
1196: l_health_plan pay_element_entry_values_f.screen_entry_value%type;

Line 1228: c_element_name pay_element_types_f.element_name%type,

1224: AND TO_CHAR(start_date,'YYYY') = c_year
1225: AND TO_CHAR(start_date,'MM') = c_month;
1226:
1227: CURSOR c_element_entry(c_assignment_id pay_element_entries_f.assignment_id%type,
1228: c_element_name pay_element_types_f.element_name%type,
1229: c_effective_date pay_element_entries_f.effective_start_date%type) IS
1230: SELECT 1
1231: FROM pay_element_entries_f ele
1232: WHERE ele.assignment_id = c_assignment_id

Line 1235: FROM pay_element_types_f elt

1231: FROM pay_element_entries_f ele
1232: WHERE ele.assignment_id = c_assignment_id
1233: AND c_effective_date BETWEEN ele.effective_start_date AND effective_end_date
1234: AND ele.element_type_id = (SELECT elt.element_type_id
1235: FROM pay_element_types_f elt
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,

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

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

Line 1253: FROM pay_element_types_f a,

1249: e.assignment_id assignment_id,
1250: e.object_version_number object_version_number,
1251: f.element_entry_value_id element_entry_value_id,
1252: f.screen_entry_value screen_entry_value
1253: FROM pay_element_types_f a,
1254: pay_input_values_f b,
1255: pay_element_entries_f e,
1256: pay_element_entry_values_f f
1257: WHERE a.element_type_id = b.element_type_id AND