[Home] [Help]
842: WHERE EXISTS(SELECT NULL
843: FROM pay_assignment_actions paa
844: ,pay_payroll_actions ppa
845: ,pay_run_results prr
846: ,pay_run_result_values prv
847: ,pay_element_types_f petf
848: ,pay_input_values_f pivf
849: WHERE paa.assignment_id = c_assignment_id
850: AND paa.ACTION_STATUS IN ('C' ,'U')
898: ,c_element_name VARCHAR2
899: ,c_input_value_name VARCHAR2) IS
900: SELECT NVL(prrv.result_value,0) Result_Value
901: FROM pay_run_results prr
902: ,pay_run_result_values prrv
903: ,pay_element_types_f pet
904: ,pay_input_values_f piv
905: where pet.element_name = c_element_name
906: AND pet.legislation_code = 'ES'
920: SELECT paa.assignment_action_id
921: FROM pay_assignment_actions paa
922: ,pay_payroll_actions ppa
923: ,pay_run_results prr
924: ,pay_run_result_values prv
925: ,pay_element_types_f petf
926: ,pay_input_values_f pivf
927: WHERE paa.assignment_id = c_assignment_id
928: AND paa.action_status IN ('C' ,'U')
946: AND pivf.effective_end_date
947: ORDER BY ppa.effective_date DESC;
948: --
949: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;
950: l_result_value pay_run_result_values.result_value%TYPE;
951: --
952: BEGIN
953: --
954: ptax_base := 0;
1148: ,min(decode(piv.name, 'Location Benefit', hr_general.decode_lookup('YES_NO',prrv.RESULT_VALUE), null)) Resident_Ceuta_Melila
1149: ,min(decode(piv.name, 'Contractual Earnings', prrv.RESULT_VALUE , null)) Calc_Cont_Earnings
1150: ,min(decode(piv.name, 'America Cup', hr_general.decode_lookup('YES_NO',prrv.RESULT_VALUE), null)) America_Cup_Flag
1151: FROM pay_run_results prr
1152: ,pay_run_result_values prrv
1153: ,pay_element_types_f pet
1154: ,pay_input_values_f piv
1155: WHERE pet.element_name = 'TWR Employee Information'
1156: AND pet.legislation_code = 'ES'
1176: ,min(decode(piv.name, 'Special Assistance', prrv.RESULT_VALUE, null)) Asc_Special_Assistance
1177: ,min(decode(piv.name, 'Special Allowance', prrv.RESULT_VALUE, null)) Asc_Special_Allowance
1178: ,min(decode(piv.name, 'Age Deduction', prrv.RESULT_VALUE, null)) Asc_Age_Deduction
1179: FROM pay_run_results prr
1180: ,pay_run_result_values prrv
1181: ,pay_element_types_f pet
1182: ,pay_input_values_f piv
1183: WHERE pet.element_name = 'TWR Employee Ascendants Information'
1184: AND pet.legislation_code = 'ES'
1204: ,min(decode(piv.name, 'Adopted less than 3 years ago', prrv.RESULT_VALUE, null)) No_Desc_Adopted_less_3
1205: ,min(decode(piv.name, 'Special Assistance', prrv.RESULT_VALUE, null)) Desc_Disability_Amt
1206: ,min(decode(piv.name, 'Disability Amount', prrv.RESULT_VALUE, null)) Desc_Special_Assistance
1207: FROM pay_run_results prr
1208: ,pay_run_result_values prrv
1209: ,pay_element_types_f pet
1210: ,pay_input_values_f piv
1211: WHERE pet.element_name = 'TWR Employee Descendants Information'
1212: AND pet.legislation_code = 'ES'
1233: ,min(decode(piv.name, 'Tax Base', prrv.RESULT_VALUE, null)) Tax_Base
1234: ,min(decode(piv.name, 'Override Tax Rate', prrv.RESULT_VALUE, null)) Override_TWR
1235: ,min(decode(piv.name, 'Override Contractual Earnings', prrv.RESULT_VALUE, null)) Override_Cont_Earnings
1236: FROM pay_run_results prr
1237: ,pay_run_result_values prrv
1238: ,pay_element_types_f pet
1239: ,pay_input_values_f piv
1240: WHERE pet.element_name = 'TWR Deduction Information'
1241: AND pet.legislation_code = 'ES'
1252: SELECT prr.assignment_action_id
1253: ,prr.run_result_id
1254: ,min(decode(piv.name, 'Rate', prrv.RESULT_VALUE, null)) Rate
1255: FROM pay_run_results prr
1256: ,pay_run_result_values prrv
1257: ,pay_element_types_f pet
1258: ,pay_input_values_f piv
1259: WHERE pet.element_name = 'Tax Withholding Rate'
1260: AND pet.legislation_code = 'ES'
1271: SELECT prr.assignment_action_id
1272: ,prr.run_result_id
1273: ,min(decode(piv.name, 'Tax Withholding Rate', prrv.RESULT_VALUE, null)) Rate
1274: FROM pay_run_results prr
1275: ,pay_run_result_values prrv
1276: ,pay_element_types_f pet
1277: ,pay_input_values_f piv
1278: WHERE pet.element_name = 'Tax'
1279: AND pet.legislation_code = 'ES'