APPS.FII_TIME_M_C dependencies on EDW_TIME_CAL_DAY_LSTG

Line 309: delete edw_time_cal_day_lstg

305: where instance = l_instance;
306:
307: commit;
308:
309: delete edw_time_cal_day_lstg
310: where instance = l_instance;
311:
312: commit;
313:

Line 413: Insert into EDW_TIME_CAL_DAY_LSTG

409: l_gl_period_fk := l_period_set_name||'-'||l_period_name ||'-' ||l_instance;
410: l_pa_period_fk := l_period_set_name||'-'||l_period_name ||'-' ||l_instance ||'-GL';
411: end if;
412:
413: Insert into EDW_TIME_CAL_DAY_LSTG
414: (
415: CAL_DAY_PK,
416: FA_PERIOD_FK,
417: PA_PERIOD_FK,

Line 516: Insert into EDW_TIME_CAL_DAY_LSTG

512:
513:
514: WHILE (e_start_date <= e_end_date)
515: LOOP
516: Insert into EDW_TIME_CAL_DAY_LSTG
517: (
518: CAL_DAY_PK,
519: FA_PERIOD_FK,
520: PA_PERIOD_FK,

Line 604: Insert into EDW_TIME_CAL_DAY_LSTG

600: l_effective_period_num;
601:
602: EXIT WHEN pa_date_cursor%NOTFOUND;
603:
604: Insert into EDW_TIME_CAL_DAY_LSTG
605: (CAL_DAY_PK,
606: FA_PERIOD_FK,
607: PA_PERIOD_FK,
608: DAY_FK,

Line 691: Insert into EDW_TIME_CAL_DAY_LSTG

687: l_effective_period_num;
688:
689: EXIT WHEN pa_period_cursor%NOTFOUND;
690:
691: Insert into EDW_TIME_CAL_DAY_LSTG
692: (CAL_DAY_PK,
693: FA_PERIOD_FK,
694: PA_PERIOD_FK,
695: DAY_FK,

Line 769: Insert into EDW_TIME_CAL_DAY_LSTG

765: l_effective_period_num;
766:
767: EXIT WHEN cal_period_cursor%NOTFOUND;
768:
769: Insert into EDW_TIME_CAL_DAY_LSTG
770: (CAL_DAY_PK,
771: FA_PERIOD_FK,
772: PA_PERIOD_FK,
773: DAY_FK,