APPS.PY_ZA_TX_01032013 dependencies on PAY_BALANCE_TYPES

Line 123: FROM pay_balance_types pbt

119: FUNCTION get_def_bal_id (p_bal_name varchar2,
120: p_dim_name varchar2) return number is
121: cursor c_get_def_bal_id is
122: SELECT pdb.defined_balance_id
123: FROM pay_balance_types pbt
124: , pay_balance_dimensions pbd
125: , pay_defined_balances pdb
126: WHERE pbt.balance_name = p_bal_name
127: AND pbd.dimension_name = p_dim_name

Line 4315: , pay_balance_types pbt

4311: , pay_run_result_values target
4312: , pay_balance_feeds_f feed
4313: , pay_run_result_values process
4314: , pay_input_values_f process_iv
4315: , pay_balance_types pbt
4316: , pay_element_types_f pet
4317: , pay_input_values_f piv
4318: WHERE paa.assignment_action_id = p_ass_action_id
4319: AND ppa.payroll_action_id = paa.payroll_action_id

Line 5095: from pay_balance_types

5091: pay_payroll_actions BACT,
5092: pay_assignment_actions BAL_ASSACT
5093: where FEED.BALANCE_TYPE_ID = (
5094: select BALANCE_TYPE_ID
5095: from pay_balance_types
5096: where balance_name= 'Tax on Lump Sums'
5097: and legislation_code = 'ZA') -- Balance_type_id for Tax on Lump Sums
5098: and BAL_ASSACT.assignment_action_id = con_ASG_ACT_ID
5099: and BAL_ASSACT.payroll_action_id = BACT.payroll_action_id

Line 5163: from pay_balance_types

5159: pay_payroll_actions BACT,
5160: pay_assignment_actions BAL_ASSACT
5161: where FEED.BALANCE_TYPE_ID = (
5162: select BALANCE_TYPE_ID
5163: from pay_balance_types
5164: where balance_name= 'Tax on Retirement Fund Lump Sums'
5165: and legislation_code = 'ZA') -- Balance_type_id for Tax on Retirement Fund Lump Sums
5166: and BAL_ASSACT.assignment_action_id = con_ASG_ACT_ID
5167: and BAL_ASSACT.payroll_action_id = BACT.payroll_action_id