APPS.PAY_US_GEO_UPD_PKG dependencies on PAY_BALANCE_VALIDATION

Line 355: l_balance_load_date pay_balance_validation.balance_load_date%type;

351:
352: lv_phase varchar2(30);
353: lv_status varchar2(2);
354:
355: l_balance_load_date pay_balance_validation.balance_load_date%type;
356: --
357: /* Bug#7240914: New variables */
358: lv_no_of_chunks number;
359: lv_count number;

Line 472: from pay_balance_validation;

468: IF chunk=1 THEN
469:
470: select min(balance_load_date)
471: into l_balance_load_date
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 */