[Home] [Help]
349: and UE.user_entity_id = DI.user_entity_id
350: and Ue.creator_type = 'B'
351: and UE.legislation_code = 'US';
352:
353: l_defined_balance_id pay_defined_balances.defined_balance_id%type;
354:
355: begin
356:
357: open csr_defined_balance;
771:
772:
773: /* Variable holding the balance to be tested. */
774:
775: l_defined_balance_id pay_defined_balances.defined_balance_id%type;
776:
777: /* Indicator variables used to control how the people are grouped. */
778:
779: l_group_by_gre boolean := FALSE;
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',
2213: 'Person in JD within GRE Year to Date',
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',
2227: 'Person within Government Reporting Entity Quarter to Date')
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',
2298: 'Person within Government Reporting Entity Year to Date'))
2384: ORDER BY pes.assignment_id, pes.effective_start_date, pes.state_code;
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;