[Home] [Help]
1024: cursor csr_input_value
1025: is
1026: select pet.element_type_id,
1027: piv.input_value_id
1028: from pay_input_values_f piv,
1029: pay_element_types_f pet,
1030: pay_payroll_actions ppa,
1031: pay_assignment_actions paa
1032: where paa.assignment_action_id = p_assignment_action_id
1126: cursor csr_input_value
1127: is
1128: select pet.element_type_id,
1129: piv.input_value_id
1130: from pay_input_values_f piv,
1131: pay_element_types_f pet,
1132: pay_payroll_actions ppa,
1133: pay_assignment_actions paa
1134: where paa.assignment_action_id = p_assignment_action_id
1187: select peevf.screen_entry_value from
1188: pay_element_entry_values_f peevf,
1189: pay_element_entries_f peef,
1190: pay_element_types_f petf,
1191: pay_input_values_f pivf
1192: WHERE peevf.element_entry_id = peef.element_entry_id
1193: and peef.element_type_id = petf.element_type_id
1194: and petf.element_name LIKE 'PREV_ER_INFO2'
1195: and petf.legislation_code = 'KR'
1205: SELECT peevf.element_entry_id element_entry_id
1206: FROM pay_element_entry_values_f peevf,
1207: pay_element_entries_f peef,
1208: pay_element_types_f petf,
1209: pay_input_values_f pivf
1210: WHERE peevf.element_entry_id = peef.element_entry_id
1211: and peef.element_type_id = petf.element_type_id
1212: and petf.element_name LIKE 'PREV_ER_INFO2'
1213: and petf.legislation_code = 'KR'
1300: cursor csr_input_value
1301: is
1302: select pet.element_type_id,
1303: piv.input_value_id
1304: from pay_input_values_f piv,
1305: pay_element_types_f pet,
1306: pay_payroll_actions ppa,
1307: pay_assignment_actions paa
1308: where paa.assignment_action_id = p_assignment_action_id
1391: -- Bug 4442482: Added new function get_result_value
1392:
1393: function get_result_value (
1394: p_run_result_id in pay_run_results.run_result_id%type,
1395: p_input_value_id in pay_input_values_f.input_value_id%type
1396: ) return varchar2 is
1397: cursor csr_result_value is
1398: select result_value
1399: from pay_run_result_values