[Home] [Help]
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
750: and piv.input_value_id = pbf.input_value_id
2724: ,PAY_BAL_ATTRIBUTE_DEFINITIONS pbad
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'
2773: pay_run_result_values prv,
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
3303: select distinct pet.reporting_name
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
4650: , pay_defined_balances pdb
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
4932: select distinct pet.reporting_name
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