DBA Data[Home] [Help]

APPS.PAY_US_GEO_UPD_PKG dependencies on PAY_POPULATION_RANGES

Line 476: from table pay_population_ranges */

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

Line 477: hr_utility.trace( 'Fetching Number of chunks created for this process 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;

Line 480: from pay_population_ranges

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);