[Home] [Help]
366: l_statutory_bal_id balance_id_tab;
367: CURSOR csr_balance_dimension(p_balance IN CHAR,
368: p_dimension IN CHAR) IS
369: SELECT pdb.defined_balance_id
370: FROM pay_balance_types pbt,
371: pay_balance_dimensions pbd,
372: pay_defined_balances pdb
373: WHERE pdb.balance_type_id = pbt.balance_type_id
374: AND pdb.balance_dimension_id = pbd.balance_dimension_id
746: cursor balance_id (bal_name varchar2, p_dimension_name varchar2) is
747: SELECT pdb.defined_balance_id
748: FROM
749: pay_balance_dimensions pbd
750: ,pay_balance_types pbt
751: ,pay_defined_balances pdb
752: WHERE
753: pbd.dimension_name = p_dimension_name
754: AND pbd.business_group_id is null
1420: -- cursor to get defined balance id
1421: -- bug 5383808
1422: cursor csr_defined_bal_id(p_balance_name varchar2) is
1423: select defined_balance_id
1424: from pay_balance_types pbt,
1425: pay_balance_dimensions pbd,
1426: pay_defined_balances pdb
1427: where pbt.balance_name = p_balance_name
1428: and pbt.balance_type_id = pdb.balance_type_id
2189:
2190: -- Bug 2943335 used balance name as a parameter
2191: CURSOR cur_defined_balance(l_balance_name IN varchar2 ) IS
2192: SELECT pdb.defined_balance_id
2193: FROM pay_balance_types pbt,
2194: pay_balance_dimensions pbd,
2195: pay_defined_balances pdb
2196: WHERE pdb.balance_type_id = pbt.balance_type_id
2197: AND pdb.balance_dimension_id = pbd.balance_dimension_id
3563:
3564: /* Split the cursor to 2 cursors to improve the performace.new parameter is added to reduce the number of
3565: tables involved to 2 from 5 (5005788) */
3566: CURSOR csr_get_def_bal(p_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE
3567: ,p_balance_name pay_balance_types.balance_name%TYPE
3568: ) IS
3569: SELECT pai1.action_information2
3570: FROM pay_action_information pai1
3571: WHERE pai1.action_context_type = 'PA'