eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GHR_NON_SF52_EXTRA_INFO dependencies on PAY_ELEMENT_ENTRIES_F

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

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

Line 1229: c_effective_date pay_element_entries_f.effective_start_date%type) IS

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

Line 1231: FROM pay_element_entries_f ele

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

Line 1241: c_effective_date pay_element_entries_f.effective_start_date%type

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

Line 1255: pay_element_entries_f e,

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