DBA Data[Home] [Help]

APPS.CHV_BUILD_SCHEDULES dependencies on CHV_CUM_PERIODS

Line 1818: FROM chv_cum_periods

1814: ORA-6502 error on 10G database.
1815: */
1816: SELECT max(to_char('Y'))
1817: INTO x_enable_cum_flag_l
1818: FROM chv_cum_periods
1819: WHERE organization_id = x_organization_id
1820: AND p_horizon_start_date between
1821: cum_period_start_date and nvl(cum_period_end_date,p_horizon_start_date+1);
1822:

Line 1847: chv_cum_periods_s2.get_cum_info (x_organization_id,

1843: ---- dbms_output.put_line('Create_items: get_cum_info');
1844:
1845: x_progress := '030';
1846: IF x_enable_cum_flag_l = 'Y' THEN
1847: chv_cum_periods_s2.get_cum_info (x_organization_id,
1848: x_vendor_id,
1849: x_vendor_site_id,
1850: x_item_id_l,
1851: p_horizon_start_date,