APPS.PAY_AU_REC_DET_PAYSUM_MODE dependencies on PAY_BALANCE_TYPES

Line 154: FROM pay_balance_types pbt,

150: 'Leave Payments Marginal',18,'Other Income',19,'Union Fees',20,
151: 'Workplace Giving Deductions' ,21) sort_index, /*4085496 */
152: pdb.defined_balance_id defined_balance_id,
153: pbt.balance_name
154: FROM pay_balance_types pbt,
155: pay_balance_dimensions pbd,
156: pay_defined_balances pdb
157: WHERE pbt.balance_name IN ('Earnings_Total','Direct Payments','Termination_Payments','Involuntary Deductions',
158: 'Pre Tax Deductions','Termination Deductions','Voluntary Deductions','Total_Tax_Deductions',

Line 187: from pay_balance_types pbt,

183: where payroll_action_id = c_payroll_action_id;
184:
185: Cursor c_fbt_balance is
186: select pdb.defined_balance_id
187: from pay_balance_types pbt,
188: pay_defined_balances pdb,
189: pay_balance_dimensions pbd
190: where pbt.balance_name ='Fringe Benefits'
191: and pbt.balance_type_id = pdb.balance_type_id

Line 654: from pay_balance_types pbt,

650: AND rppa.payroll_id = paaf.payroll_id );
651:
652: Cursor c_fbt_balance is
653: select pdb.defined_balance_id
654: from pay_balance_types pbt,
655: pay_defined_balances pdb,
656: pay_balance_dimensions pbd
657: where pbt.balance_name ='Fringe Benefits'
658: and pbt.balance_type_id = pdb.balance_type_id

Line 1612: pay_balance_types pbt

1608: and NOT EXISTS
1609: (
1610: select 1
1611: from pay_balance_feeds_f pbf,
1612: pay_balance_types pbt
1613: where pbt.balance_type_id = pbf.balance_type_id
1614: and pbt.balance_name in ('Invalidity Payments','Lump Sum A Payments',
1615: 'Lump Sum B Payments','Lump Sum C Payments',
1616: 'Lump Sum D Payments','Lump Sum E Payments')/*Bug 5846278 */

Line 1853: FROM pay_balance_types pbt,

1849: select sum(pay_balance_pkg.get_value(pdb.defined_balance_id,
1850: c_assignment_action_id,
1851: c_tax_unit_id,
1852: null,null,null,null)) --2610141
1853: FROM pay_balance_types pbt,
1854: pay_defined_balances pdb,
1855: pay_balance_dimensions pbd
1856: WHERE pbt.legislation_code = 'AU'
1857: AND pbt.balance_name = 'Lump Sum E Payments'

Line 1949: cursor c_allowance_balance(c_balance_type_id pay_balance_types.balance_type_id%type)

1945: procedure get_allowance_balances(p_assignment_id in pay_assignment_actions.assignment_id%type
1946: ,p_run_assignment_action_id in pay_assignment_actions.assignment_action_id%type)
1947: is
1948:
1949: cursor c_allowance_balance(c_balance_type_id pay_balance_types.balance_type_id%type)
1950: is
1951: select nvl(pbt.reporting_name,pbt.balance_name) balance_name, /* Bug 5743196 added nvl */
1952: pdb.defined_balance_id
1953: from pay_balance_types pbt

Line 1953: from pay_balance_types pbt

1949: cursor c_allowance_balance(c_balance_type_id pay_balance_types.balance_type_id%type)
1950: is
1951: select nvl(pbt.reporting_name,pbt.balance_name) balance_name, /* Bug 5743196 added nvl */
1952: pdb.defined_balance_id
1953: from pay_balance_types pbt
1954: ,pay_defined_balances pdb
1955: ,pay_balance_dimensions pbd
1956: where pbt.balance_type_id = c_balance_type_id
1957: and pdb.balance_type_id = pbt.balance_type_id