[Home] [Help]
472: from pay_balance_validation;
473: open c_actions_run_bal(pactid,l_balance_load_date);
474:
475: /* Bug#7240914: Fetch number of chunks created for the current run
476: from table pay_population_ranges */
477: hr_utility.trace( 'Fetching Number of chunks created for this process from pay_population_ranges.');
478: select max(chunk_number)
479: into lv_no_of_chunks
480: from pay_population_ranges
473: open c_actions_run_bal(pactid,l_balance_load_date);
474:
475: /* Bug#7240914: Fetch number of chunks created for the current run
476: from table pay_population_ranges */
477: hr_utility.trace( 'Fetching Number of chunks created for this process from pay_population_ranges.');
478: select max(chunk_number)
479: into lv_no_of_chunks
480: from pay_population_ranges
481: where payroll_action_id = pactid;
476: from table pay_population_ranges */
477: hr_utility.trace( 'Fetching Number of chunks created for this process from pay_population_ranges.');
478: select max(chunk_number)
479: into lv_no_of_chunks
480: from pay_population_ranges
481: where payroll_action_id = pactid;
482:
483: hr_utility.trace( 'Number of chunks: ' || to_char(lv_no_of_chunks));
484: lv_no_of_chunks := NVL(lv_no_of_chunks,0);