DBA Data[Home] [Help]

APPS.HRI_TIME_C dependencies on HRI_TIME_CAL_GT

Line 1974: Insert into HRI_time_cal_gt(calendar_id)

1970: -- determine if any rows will be different between current set per
1971: -- gl tables and current set per HRI tables
1972: --Bug 3543939. Get the Calendar id's into a temporary table for use in Load_Time_Cal_Rpt_Struct
1973:
1974: Insert into HRI_time_cal_gt(calendar_id)
1975: select calendar_id
1976: from (
1977: (select
1978: to_number(lpad(cal_name.calendar_id,3,'0')||glp.period_year||glp.quarter_num||decode(length(glp.period_num),1,'0'||glp.period_num, glp.period_num))

Line 2046: from HRI_time_cal_gt

2042:
2043: -- Bug 4966868: Changed not to count rows
2044: BEGIN
2045: select 1 into l_diff_rows
2046: from HRI_time_cal_gt
2047: where rownum = 1;
2048: EXCEPTION
2049: WHEN NO_DATA_FOUND THEN
2050: l_diff_rows := 0;

Line 3759: FROM HRI_time_cal_gt) LOOP

3755: --Bug 3543939. The Calendar id's to be picked from the temporary table populated in Load_Cal_Period
3756:
3757: For cur_Fiscal_Calendar IN (
3758: SELECT distinct calendar_id
3759: FROM HRI_time_cal_gt) LOOP
3760:
3761: --Reset the l_from_date and l_to_date to the parameters passed
3762:
3763: l_from_date:=p_from_date;