APPS.PAY_AU_REC_DET_PAYSUM_MODE dependencies on PAY_BALANCE_DIMENSIONS

Line 155: pay_balance_dimensions pbd,

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',
159: 'Earnings_Non_Taxable','Employer_Charges','Lump Sum A Payments','Lump Sum B Payments','Lump Sum C Payments',

Line 189: pay_balance_dimensions pbd

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
192: and pdb.balance_dimension_id = pbd.balance_dimension_id /* Bug 2501105 */
193: and pbd.legislation_code ='AU'

Line 656: pay_balance_dimensions pbd

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
659: and pdb.balance_dimension_id = pbd.balance_dimension_id /* Bug 2501105 */
660: and pbd.legislation_code ='AU'

Line 1855: pay_balance_dimensions pbd

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'
1858: AND pbt.balance_type_id = pdb.balance_type_id
1859: AND pbd.balance_dimension_id = pdb.balance_dimension_id

Line 1955: ,pay_balance_dimensions pbd

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
1958: and pdb.balance_dimension_id = pbd.balance_dimension_id
1959: and pbd.dimension_name = '_ASG_LE_YTD'