APPS.PAY_AU_PAYMENT_SUMMARY dependencies on PAY_INPUT_VALUES_F

Line 745: , pay_input_values_f piv

741: cursor c_get_fw_union_bal_type_id is
742: select distinct pbt.balance_type_id
743: from pay_element_types_f pet
744: , pay_balance_types pbt
745: , pay_input_values_f piv
746: , pay_balance_feeds_f pbf
747: where pet.element_information_category = 'AU_VOLUNTARY DEDUCTIONS'
748: and pet.element_information1 = pbt.balance_type_id
749: and pet.element_type_id = piv.element_type_id

Line 2729: ,pay_input_values_f piv

2725: , PAY_BALANCE_ATTRIBUTES pba
2726: ,pay_defined_balances pdb
2727: ,pay_balance_dimensions pbd
2728: ,PAY_BALANCE_FEEDS_F pbf
2729: ,pay_input_values_f piv
2730: WHERE paa.assignment_id = c_assignment_id
2731: /* start added for bug 7571001 */
2732: AND pbad.attribute_name = 'AU_EOY_ALLOWANCE'
2733: AND pbad.legislation_code = 'AU'

Line 2778: ,pay_input_values_f piv

2774: pay_element_types_f pet,
2775: pay_balance_types pbt
2776: /* below added for bug 7571001 */
2777: ,PAY_BALANCE_FEEDS_F pbf
2778: ,pay_input_values_f piv
2779: where
2780: pee.element_entry_id=c_element_entry_id
2781: and prv.run_result_id=prr.run_result_id
2782: AND pee.element_entry_id=prr.source_id

Line 3308: , pay_input_values_f piv

3304: , pet.element_information_category
3305: , pet.element_information1
3306: from pay_balance_types pbt
3307: , pay_balance_feeds_f pbf
3308: , pay_input_values_f piv
3309: , pay_element_types_f pet
3310: , pay_element_entries_f pee
3311: , pay_element_links_f pel
3312: , per_all_people_f pap

Line 4442: ,pay_input_values_f piv

4438: ,ppa.payroll_action_id
4439: ,pac.assignment_action_id
4440: ,ppa.effective_date
4441: from pay_element_types_f pet
4442: ,pay_input_values_f piv
4443: ,per_all_assignments_f paa
4444: ,pay_run_results prr
4445: ,pay_run_result_values prv
4446: ,pay_assignment_actions pac

Line 4655: , pay_input_values_f piv

4651: , pay_payroll_actions ppa
4652: , pay_assignment_actions pac
4653: , pay_run_results prr
4654: , pay_balance_feeds_f pbf
4655: , pay_input_values_f piv
4656: where pac.assignment_id = p_assignment_id
4657: and pac.tax_unit_id = p_registered_employer
4658: and paa.assignment_id = pac.assignment_id
4659: and paa.assignment_id = p_assignment_id

Line 4937: , pay_input_values_f piv

4933: , pet.element_information_category
4934: , pet.element_information1
4935: from pay_balance_types pbt
4936: , pay_balance_feeds_f pbf
4937: , pay_input_values_f piv
4938: , pay_element_types_f pet
4939: , pay_element_entries_f pee
4940: , pay_element_links_f pel
4941: , per_all_people_f pap

Line 5173: pay_input_values_f piv,

5169: from hr_organization_information hoi,
5170: hr_organization_units hou,
5171: hr_soft_coding_keyflex hsc,
5172: pay_element_types_f pet,
5173: pay_input_values_f piv,
5174: pay_element_links_f pel,
5175: pay_element_entries_f pee,
5176: pay_element_entry_values_f pev,
5177: per_all_assignments_f paa,

Line 5239: ,pay_input_values_f piv

5235: c_year_start date ,
5236: c_year_end date ) IS
5237: select prv.result_value INPUT_VALUE,piv.name INPUT_NAME
5238: from pay_element_types_f pet
5239: ,pay_input_values_f piv
5240: ,per_all_assignments_f paa
5241: ,pay_run_results prr
5242: ,pay_run_result_values prv
5243: ,pay_assignment_actions pac

Line 7250: pay_input_values_f piv,

7246: is
7247: select pev.screen_entry_value tfn_no
7248: from
7249: pay_element_types_f pet,
7250: pay_input_values_f piv,
7251: pay_element_links_f pel,
7252: pay_element_entries_f pee,
7253: pay_element_entry_values_f pev
7254: where pet.element_name = 'Tax Information'

Line 9654: ,pay_input_values_f piv

9650: ,pay_element_entries_f pee
9651: ,pay_run_results prr
9652: ,pay_run_result_values prv
9653: ,pay_element_types_f pet
9654: ,pay_input_values_f piv
9655: ,pay_element_classifications pec
9656: WHERE paa.assignment_id = p_assignment_id
9657: AND pps.PERIOD_OF_SERVICE_ID = paa.PERIOD_OF_SERVICE_ID
9658: AND NVL(pps.actual_termination_date, p_end_date)