[Home] [Help]
12: --
13: CURSOR c_payment_key(c_element_name VARCHAR2
14: ,c_input_value_name VARCHAR2) IS
15: SELECT eev.screen_entry_value payment_key
16: FROM pay_element_types_f pet
17: ,pay_input_values_f piv
18: ,pay_element_entry_values_f eev
19: ,pay_element_entries_f pee
20: WHERE pee.assignment_id = passignment_id
664: SELECT 'Y'
665: FROM DUAL
666: WHERE EXISTS(SELECT 1
667: FROM pay_element_entries_f pee
668: ,pay_element_types_f pet
669: WHERE pee.assignment_id = c_assignment_id
670: AND pee.element_type_id = pet.element_type_id
671: AND pet.element_name = 'Tax Withholding Rate'
672: AND pet.legislation_code= 'ES'
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')
851: AND ppa.payroll_action_id = paa.payroll_action_id
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'
907: AND piv.element_type_id = pet.element_type_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')
929: AND ppa.payroll_action_id = paa.payroll_action_id
1099: AND ((paa.source_action_id IS NULL and paa.action_status = 'E')
1100: or (paa.source_action_id IS NOT NULL
1101: AND exists (select 1
1102: FROM pay_run_results r
1103: ,pay_element_types_f pet
1104: WHERE paa.assignment_action_id = r.assignment_action_id
1105: AND pet.element_type_id = r.element_type_id
1106: AND pet.legislation_code = 'ES'
1107: AND pet.element_name in ('Tax Withholding Rate','Tax'))))
1111: --
1112: CURSOR csr_chk_emp_err(c_assignment_action_id number, c_effective_date DATE) IS
1113: SELECT 'N'
1114: FROM PAY_RUN_RESULTs prr
1115: ,pay_element_types_f pet
1116: WHERE prr.assignment_action_id = c_assignment_action_id
1117: AND prr.element_type_id = pet.element_type_id
1118: AND pet.element_name = 'TWR Employee Information'
1119: AND c_effective_date BETWEEN pet.effective_start_date AND pet.effective_end_date;
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'
1157: AND piv.element_type_id =pet.element_type_id
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'
1185: AND piv.element_type_id =pet.element_type_id
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'
1213: AND piv.element_type_id =pet.element_type_id
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'
1242: AND piv.element_type_id =pet.element_type_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'
1261: AND piv.element_type_id =pet.element_type_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'
1280: AND piv.element_type_id =pet.element_type_id
1966: FROM per_all_assignments_f paaf
1967: ,hr_soft_coding_keyflex scl
1968: ,pay_element_entries_f pee
1969: ,pay_element_entry_values_f peev
1970: ,pay_element_types_f pet
1971: ,pay_input_values_f piv
1972: WHERE paaf.person_id = c_person_id
1973: AND paaf.soft_coding_keyflex_id = scl.soft_coding_keyflex_id
1974: AND scl.segment2 = c_work_center