694: CURSOR csr_input_value_id(p_element_name CHAR,
695: p_value_name CHAR) IS
696: SELECT pet.element_type_id,
697: piv.input_value_id
698: FROM pay_input_values_f piv,
699: pay_element_types_f pet
700: WHERE piv.element_type_id = pet.element_type_id
701: AND pet.legislation_code = 'IE'
702: AND pet.element_name = p_element_name
1549: , per_time_periods PPTP
1550: , per_time_periods BPTP
1551: , pay_run_results PROCESS_RR
1552: , pay_run_result_values PROCESS
1553: , pay_input_values_f PROCESS_IV
1554: , pay_action_contexts ACX_PROCESS_ID
1555: , ff_contexts CON_PROCESS_ID
1556: where BAL_ASSACT.assignment_action_id = p_source_id
1557: and BAL_ASSACT.payroll_action_id = BACT.payroll_action_id
2893: cursor cur_non_cum_tax is
2894: select result_value
2895: from pay_run_result_values prr,
2896: pay_run_results pr,
2897: pay_input_values_f piv,
2898: pay_assignment_actions pas,
2899: pay_payroll_actions ppa
2900: where pas.assignment_id in (select assignment_id
2901: from per_all_assignments_f
3222: CURSOR csr_input_value_id(p_element_name CHAR,
3223: p_value_name CHAR) IS
3224: SELECT pet.element_type_id,
3225: piv.input_value_id
3226: FROM pay_input_values_f piv,
3227: pay_element_types_f pet
3228: WHERE piv.element_type_id = pet.element_type_id
3229: AND pet.legislation_code = 'IE'
3230: AND pet.element_name = p_element_name