APPS.PJI_PMV_ENGINE dependencies on FII_TIME_CAL_RPT_STRUCT

Line 2098: FROM fii_time_cal_rpt_struct

2094: IF l_IS_GL_Flag IS NOT NULL THEN
2095: INSERT INTO PJI_PMV_TIME_DIM_TMP
2096: (ID, NAME, ORDER_BY_ID, PERIOD_TYPE, AMOUNT_TYPE, CALENDAR_TYPE)
2097: SELECT time_id, l_Default_Period_Name, l_Default_Period_ID, period_type_id, 1 , calendar_type
2098: FROM fii_time_cal_rpt_struct
2099: WHERE report_date = l_As_Of_Date
2100: AND bitand(record_type_id,l_Level) = record_type_id
2101: AND calendar_id = l_Calendar_Id;
2102: ELSE

Line 2120: FROM fii_time_cal_rpt_struct

2116: IF l_IS_GL_Flag IS NOT NULL THEN
2117: INSERT INTO PJI_PMV_TIME_DIM_TMP
2118: (PRIOR_ID, NAME, ORDER_BY_ID, PERIOD_TYPE, AMOUNT_TYPE, CALENDAR_TYPE)
2119: SELECT time_id, l_Default_Period_Name, l_Default_Period_ID, period_type_id, 1, calendar_type
2120: FROM fii_time_cal_rpt_struct
2121: WHERE report_date = l_Prior_As_Of_Date
2122: AND bitand(record_type_id,l_Level) = record_type_id
2123: AND calendar_id = l_Calendar_Id;
2124: ELSE

Line 2874: FROM fii_time_cal_rpt_struct

2870: IF l_IS_GL_Flag IS NOT NULL THEN
2871: INSERT INTO PJI_PMV_TCMP_DIM_TMP
2872: (ID, NAME, PERIOD_TYPE, AMOUNT_TYPE, CALENDAR_TYPE)
2873: SELECT time_id, '-1', period_type_id, 1 , calendar_type
2874: FROM fii_time_cal_rpt_struct
2875: WHERE report_date = l_As_Of_Date
2876: AND bitand(record_type_id,l_Level) = record_type_id
2877: AND calendar_id = l_Calendar_Id;
2878: ELSE

Line 3066: FROM fii_time_cal_rpt_struct

3062: IF l_IS_GL_Flag IS NOT NULL THEN
3063: INSERT INTO PJI_PMV_ITD_DIM_TMP
3064: (ID, NAME, ORDER_BY_ID, PERIOD_TYPE, COMPARATOR_TYPE, CALENDAR_TYPE)
3065: SELECT time_id, '-1' , '-1' , period_type_id, p_Comparator, calendar_type
3066: FROM fii_time_cal_rpt_struct
3067: WHERE report_date = l_As_Of_Date
3068: AND bitand(record_type_id,1143) = record_type_id
3069: AND calendar_id = l_Calendar_Id;
3070: ELSE

Line 3088: FROM fii_time_cal_rpt_struct

3084: IF l_IS_GL_Flag IS NOT NULL THEN
3085: INSERT INTO PJI_PMV_ITD_DIM_TMP
3086: (PRIOR_ID, NAME, ORDER_BY_ID, PERIOD_TYPE, COMPARATOR_TYPE, CALENDAR_TYPE)
3087: SELECT time_id, '-1', '-1', period_type_id, p_Comparator, calendar_type
3088: FROM fii_time_cal_rpt_struct
3089: WHERE report_date = l_Prior_As_Of_Date
3090: AND bitand(record_type_id,1143) = record_type_id
3091: AND calendar_id = l_Calendar_Id;
3092: ELSE

Line 3121: FROM fii_time_cal_rpt_struct

3117:
3118: INSERT INTO PJI_PMV_ITD_DIM_TMP
3119: (ID, NAME, ORDER_BY_ID, PERIOD_TYPE, COMPARATOR_TYPE, CALENDAR_TYPE)
3120: SELECT time_id, '-1', '-1', period_type_id, p_Comparator, 'P'
3121: FROM fii_time_cal_rpt_struct
3122: WHERE report_date = l_As_Of_Date
3123: AND bitand(record_type_id,1143) = record_type_id
3124: AND calendar_id = l_Calendar_Id
3125: AND period_type_id > 16;

Line 3144: FROM fii_time_cal_rpt_struct

3140:
3141: INSERT INTO PJI_PMV_ITD_DIM_TMP
3142: (PRIOR_ID, NAME, ORDER_BY_ID, PERIOD_TYPE, COMPARATOR_TYPE, CALENDAR_TYPE)
3143: SELECT time_id, '-1', '-1', period_type_id, p_Comparator, 'P'
3144: FROM fii_time_cal_rpt_struct
3145: WHERE report_date = l_As_Of_Date
3146: AND bitand(record_type_id,1143) = record_type_id
3147: AND calendar_id = l_Calendar_Id
3148: AND period_type_id > 16;

Line 3431: FROM fii_time_cal_rpt_struct

3427: IF l_IS_GL_Flag IS NOT NULL THEN
3428: INSERT INTO PJI_PMV_TIME_DIM_TMP
3429: (ID, NAME, ORDER_BY_ID, PERIOD_TYPE, AMOUNT_TYPE, CALENDAR_TYPE)
3430: SELECT time_id, l_Def_View_BY, l_Def_View_BY_ID, period_type_id, 1 , calendar_type
3431: FROM fii_time_cal_rpt_struct
3432: WHERE report_date = l_As_Of_Date
3433: AND bitand(record_type_id,l_Level) = record_type_id
3434: AND calendar_id = l_Calendar_Id;
3435: ELSE

Line 3453: FROM fii_time_cal_rpt_struct

3449: IF l_IS_GL_Flag IS NOT NULL THEN
3450: INSERT INTO PJI_PMV_TIME_DIM_TMP
3451: (PRIOR_ID, NAME, ORDER_BY_ID, PERIOD_TYPE, AMOUNT_TYPE, CALENDAR_TYPE)
3452: SELECT time_id, l_Def_View_BY, l_Def_View_BY_ID, period_type_id, 1, calendar_type
3453: FROM fii_time_cal_rpt_struct
3454: WHERE report_date = l_Prior_As_Of_Date
3455: AND bitand(record_type_id,l_Level) = record_type_id
3456: AND calendar_id = l_Calendar_Id;
3457: ELSE