[Home] [Help]
2204:
2205: CURSOR get_defined_balance_id IS
2206: select pdb.defined_balance_id,pbd.dimension_name
2207: from pay_balance_types pbt,
2208: pay_balance_dimensions pbd,
2209: pay_defined_balances pdb
2210: where pbt.legislation_code = 'US'
2211: and pbt.balance_name = 'SUI ER Taxable'
2212: and pbd.dimension_name in ('Person in JD within GRE Quarter to Date',
2218:
2219: CURSOR c_get_defined_balance_id_oh IS
2220: select pdb.defined_balance_id,pbd.dimension_name
2221: from pay_balance_types pbt,
2222: pay_balance_dimensions pbd,
2223: pay_defined_balances pdb
2224: where pbt.legislation_code = 'US'
2225: and pbt.balance_name = 'SUI ER Taxable'
2226: and pbd.dimension_name in ('Person in JD within GRE Quarter to Date',
2289: -- Cursor to get the Defined Balance IDs
2290: CURSOR c_get_defined_balance_id_ar IS
2291: select pdb.defined_balance_id, pbt.balance_name, pbd.dimension_name
2292: from pay_balance_types pbt,
2293: pay_balance_dimensions pbd,
2294: pay_defined_balances pdb
2295: where pbt.legislation_code = 'US'
2296: and (( pbt.balance_name = 'SUI ER Taxable'
2297: and pbd.dimension_name in ('Person in JD within GRE Year to Date',
2385:
2386: /* Added for Bug#14097843 ends here */
2387:
2388: l_def_bal_id pay_defined_balances.defined_balance_id%TYPE;
2389: l_dimension_name pay_balance_dimensions.dimension_name%TYPE;
2390:
2391: l_sui_fl_taxable_qtd number;
2392: l_sui_fl_taxable_ytd number;
2393: l_sui_taxable_ytd number;