eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_ES_TWR_CALC_PKG dependencies on PAY_RUN_RESULTS

Line 845: ,pay_run_results prr

841: FROM dual
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

Line 901: FROM pay_run_results prr

897: ,c_effective_date DATE
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

Line 923: ,pay_run_results prr

919: ,c_effective_date DATE) IS
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

Line 1102: FROM pay_run_results r

1098: AND paaf.assignment_id = paa.assignment_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'

Line 1114: FROM PAY_RUN_RESULTs prr

1110: AND ppa.effective_date BETWEEN prtf.effective_start_date AND prtf.effective_end_date;
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'

Line 1151: FROM pay_run_results prr

1147: ,min(decode(piv.name, 'Work Status', substr(prrv.RESULT_VALUE||' - '||hr_general.decode_lookup('ES_WORKER_STATUS',prrv.RESULT_VALUE),1,10) , null)) Work_Status
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'

Line 1179: FROM pay_run_results prr

1175: ,min(decode(piv.name, 'Disability Amount', prrv.RESULT_VALUE, null)) Asc_Disability_Amt
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'

Line 1207: FROM pay_run_results prr

1203: ,min(decode(piv.name, 'Single Parent', prrv.RESULT_VALUE, null)) No_Desc_Single_Parent
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'

Line 1236: FROM pay_run_results prr

1232: ,min(decode(piv.name, 'Spouse Alimony', prrv.RESULT_VALUE, null)) Spouse_Alimony
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'

Line 1255: FROM pay_run_results prr

1251: CURSOR csr_get_twr_rate(c_assignment_action_id number, c_effective_date DATE)IS
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'

Line 1274: FROM pay_run_results prr

1270: CURSOR csr_get_tax_rate(c_assignment_action_id number, c_effective_date DATE)IS
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'