505: CURSOR csr_input_value_id(p_element_name CHAR,
506: p_value_name CHAR) IS
507: SELECT pet.element_type_id,
508: piv.input_value_id
509: FROM pay_input_values_f piv,
510: pay_element_types_f pet
511: WHERE piv.element_type_id = pet.element_type_id
512: AND pet.legislation_code = 'IE'
513: AND pet.element_name = p_element_name
1285: , per_time_periods PPTP
1286: , per_time_periods BPTP
1287: , pay_run_results PROCESS_RR
1288: , pay_run_result_values PROCESS
1289: , pay_input_values_f PROCESS_IV
1290: , pay_action_contexts ACX_PROCESS_ID
1291: , ff_contexts CON_PROCESS_ID
1292: where BAL_ASSACT.assignment_action_id = p_source_id
1293: and BAL_ASSACT.payroll_action_id = BACT.payroll_action_id
2226: cursor cur_non_cum_tax is
2227: select result_value
2228: from pay_run_result_values prr,
2229: pay_run_results pr,
2230: pay_input_values_f piv,
2231: pay_assignment_actions pas,
2232: pay_payroll_actions ppa
2233: where pas.assignment_id in (select assignment_id
2234: from per_all_assignments_f
2516: CURSOR csr_input_value_id(p_element_name CHAR,
2517: p_value_name CHAR) IS
2518: SELECT pet.element_type_id,
2519: piv.input_value_id
2520: FROM pay_input_values_f piv,
2521: pay_element_types_f pet
2522: WHERE piv.element_type_id = pet.element_type_id
2523: AND pet.legislation_code = 'IE'
2524: AND pet.element_name = p_element_name