108: cursor get_all_bals (p_pact_id in number
109: ) is
110: select pdb.defined_balance_id,
111: ppa.business_group_id,
112: nvl(pay_core_utils.get_parameter('BAL_LVL',
113: ppa.legislative_parameters),
114: 'BOTH') balance_level,
115: pbd.dimension_level
116: from pay_payroll_actions ppa,
131: and pdb.save_run_balance = 'Y'
132: and pbd.dimension_type = 'R'
133: and pdb.balance_dimension_id = pbd.balance_dimension_id
134: and ((pbd.dimension_level =
135: nvl(pay_core_utils.get_parameter('BAL_LVL',
136: ppa.legislative_parameters),
137: 'BOTH'))
138: or
139: (nvl(pay_core_utils.get_parameter('BAL_LVL',
135: nvl(pay_core_utils.get_parameter('BAL_LVL',
136: ppa.legislative_parameters),
137: 'BOTH'))
138: or
139: (nvl(pay_core_utils.get_parameter('BAL_LVL',
140: ppa.legislative_parameters),
141: 'BOTH')
142: = 'BOTH')
143: );
301: g_globals_set := TRUE;
302: --
303: /* Get parameters */
304: select
305: pay_core_utils.get_parameter('DEF_BAL_ID',
306: pa1.legislative_parameters),
307: nvl(pay_core_utils.get_parameter('BAL_LVL',
308: pa1.legislative_parameters),
309: 'BOTH'),
303: /* Get parameters */
304: select
305: pay_core_utils.get_parameter('DEF_BAL_ID',
306: pa1.legislative_parameters),
307: nvl(pay_core_utils.get_parameter('BAL_LVL',
308: pa1.legislative_parameters),
309: 'BOTH'),
310: nvl(pay_core_utils.get_parameter('PROC_MODE',
311: pa1.legislative_parameters),
306: pa1.legislative_parameters),
307: nvl(pay_core_utils.get_parameter('BAL_LVL',
308: pa1.legislative_parameters),
309: 'BOTH'),
310: nvl(pay_core_utils.get_parameter('PROC_MODE',
311: pa1.legislative_parameters),
312: 'ALL'),
313: to_date(pay_core_utils.get_parameter('BAL_START_DATE',
314: pa1.legislative_parameters),
309: 'BOTH'),
310: nvl(pay_core_utils.get_parameter('PROC_MODE',
311: pa1.legislative_parameters),
312: 'ALL'),
313: to_date(pay_core_utils.get_parameter('BAL_START_DATE',
314: pa1.legislative_parameters),
315: 'YYYY/MM/DD'),
316: nvl(pay_core_utils.get_parameter('LOAD_TYPE',
317: pa1.legislative_parameters),
312: 'ALL'),
313: to_date(pay_core_utils.get_parameter('BAL_START_DATE',
314: pa1.legislative_parameters),
315: 'YYYY/MM/DD'),
316: nvl(pay_core_utils.get_parameter('LOAD_TYPE',
317: pa1.legislative_parameters),
318: 'ALL'),
319: pbg.legislation_code,
320: pbg.business_group_id,
1868: g_purge_only := FALSE;
1869: set_globals(p_payroll_action_id);
1870:
1871: select business_group_id, request_id,
1872: nvl(pay_core_utils.get_parameter('PURGE_ONLY', legislative_parameters), 'N') parm_purge_only
1873: into l_bus_grp, l_request_id, l_parm_purge_only
1874: from pay_payroll_actions
1875: where payroll_action_id = p_payroll_action_id;
1876:
1995: /* Set the Balance Status */
1996: --
1997: set_run_bal_status(pactid, 'V');
1998: --
1999: select pay_core_utils.get_parameter('REMOVE_ACT',
2000: pa1.legislative_parameters)
2001: into remove_act
2002: from pay_payroll_actions pa1
2003: where pa1.payroll_action_id = pactid;