APPS.GHR_NON_SF52_EXTRA_INFO dependencies on PAY_ELEMENT_ENTRIES_F

Line 1085: CURSOR c_element_entry(c_assignment_id pay_element_entries_f.assignment_id%type,

1081: WHERE payroll_id = c_payroll_id
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

Line 1087: c_effective_date pay_element_entries_f.effective_start_date%type) IS

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
1091: AND c_effective_date BETWEEN ele.effective_start_date AND effective_end_date

Line 1089: FROM pay_element_entries_f ele

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
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

Line 1099: c_effective_date pay_element_entries_f.effective_start_date%type

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,
1103: f.input_value_id input_value_id,

Line 1113: pay_element_entries_f e,

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
1116: e.element_type_id = a.element_type_id AND
1117: f.element_entry_id = e.element_entry_id AND