DBA Data[Home] [Help]

APPS.PAY_AU_RECONCILIATION_PKG dependencies on PAY_BALANCE_DIMENSIONS

Line 209: (c_database_item_suffix pay_balance_dimensions.database_item_suffix%type)

205: (p_ytd_totals varchar2,
206: p_registered_employer NUMBER) IS --2610141
207:
208: CURSOR csr_defined_balance_id
209: (c_database_item_suffix pay_balance_dimensions.database_item_suffix%type)
210: IS
211: SELECT decode(pbt.balance_name,'Earnings_Total',1,'Direct Payments',2,'Termination_Payments',3,
212: 'Involuntary Deductions',4,'Pre Tax Deductions',5,'Termination Deductions',6,
213: 'Voluntary Deductions',7,'Total_Tax_Deductions',8,'Earnings_Non_Taxable',9,

Line 217: pay_balance_dimensions pbd,

213: 'Voluntary Deductions',7,'Total_Tax_Deductions',8,'Earnings_Non_Taxable',9,
214: 'Employer_Charges',10) sort_index,
215: pdb.defined_balance_id defined_balance_id
216: FROM pay_balance_types pbt,
217: pay_balance_dimensions pbd,
218: pay_defined_balances pdb
219: WHERE pbt.balance_name IN ('Earnings_Total','Direct Payments','Termination_Payments','Involuntary Deductions',
220: 'Pre Tax Deductions','Termination Deductions','Voluntary Deductions','Total_Tax_Deductions',
221: 'Earnings_Non_Taxable','Employer_Charges')