APPS.PAY_ES_TWR_CALC_PKG dependencies on PAY_INPUT_VALUES_F

Line 17: ,pay_input_values_f piv

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
21: AND pee.element_type_id = pet.element_type_id

Line 848: ,pay_input_values_f pivf

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
852: and ppa.action_status IN ('C' ,'U')

Line 904: ,pay_input_values_f piv

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
908: AND piv.name = c_input_value_name

Line 926: ,pay_input_values_f pivf

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
930: AND ppa.action_type IN ('Q' ,'R')

Line 1154: ,pay_input_values_f piv

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
1158: AND pet.element_type_id = prr.element_type_id

Line 1182: ,pay_input_values_f piv

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
1186: AND pet.element_type_id = prr.element_type_id

Line 1210: ,pay_input_values_f piv

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
1214: AND pet.element_type_id = prr.element_type_id

Line 1239: ,pay_input_values_f piv

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
1243: AND pet.element_type_id = prr.element_type_id

Line 1258: ,pay_input_values_f piv

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
1262: AND pet.element_type_id = prr.element_type_id

Line 1277: ,pay_input_values_f piv

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
1281: AND pet.element_type_id = prr.element_type_id

Line 1971: ,pay_input_values_f piv

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
1975: AND pee.assignment_id = paaf.assignment_id