APPS.PJI_PMV_ENGINE dependencies on FII_TIME_RPT_STRUCT

Line 2106: FROM fii_time_rpt_struct

2102: ELSE
2103: INSERT INTO PJI_PMV_TIME_DIM_TMP
2104: (ID, NAME, ORDER_BY_ID, PERIOD_TYPE, AMOUNT_TYPE, CALENDAR_TYPE)
2105: SELECT time_id, l_Default_Period_Name, l_Default_Period_ID, period_type_id, 1 , calendar_type
2106: FROM fii_time_rpt_struct
2107: WHERE report_date = l_As_Of_Date
2108: AND bitand(record_type_id,l_Level) = record_type_id
2109: AND calendar_id = l_Calendar_Id;
2110: END IF;

Line 2128: FROM fii_time_rpt_struct

2124: ELSE
2125: INSERT INTO PJI_PMV_TIME_DIM_TMP
2126: (PRIOR_ID, NAME, ORDER_BY_ID, PERIOD_TYPE, AMOUNT_TYPE, CALENDAR_TYPE)
2127: SELECT time_id, l_Default_Period_Name, l_Default_Period_ID, period_type_id, 1, calendar_type
2128: FROM fii_time_rpt_struct
2129: WHERE report_date = l_Prior_As_Of_Date
2130: AND bitand(record_type_id,l_Level) = record_type_id
2131: AND calendar_id = l_Calendar_Id;
2132: END IF;

Line 2248: FROM fii_time_rpt_struct

2244: l_Level:=11;
2245: INSERT INTO PJI_PMV_TIME_DIM_TMP
2246: (ID, NAME, ORDER_BY_ID, PERIOD_TYPE, AMOUNT_TYPE, CALENDAR_TYPE)
2247: SELECT time_id, l_Default_Period_Name, l_Default_Period_ID, period_type_id, 1 , calendar_type
2248: FROM fii_time_rpt_struct
2249: WHERE report_date = l_As_Of_Date
2250: AND bitand(record_type_id,l_Level) = record_type_id
2251: AND calendar_id = l_Calendar_Id;
2252:

Line 2882: FROM fii_time_rpt_struct

2878: ELSE
2879: INSERT INTO PJI_PMV_TCMP_DIM_TMP
2880: (ID, NAME, PERIOD_TYPE, AMOUNT_TYPE, CALENDAR_TYPE)
2881: SELECT time_id, '-1', period_type_id, 1 , calendar_type
2882: FROM fii_time_rpt_struct
2883: WHERE report_date = l_As_Of_Date
2884: AND bitand(record_type_id,l_Level) = record_type_id
2885: AND calendar_id = l_Calendar_Id;
2886: END IF;

Line 3074: FROM fii_time_rpt_struct

3070: ELSE
3071: INSERT INTO PJI_PMV_ITD_DIM_TMP
3072: (ID, NAME, ORDER_BY_ID, PERIOD_TYPE, COMPARATOR_TYPE, CALENDAR_TYPE)
3073: SELECT time_id, '-1' , '-1' , period_type_id, p_Comparator, calendar_type
3074: FROM fii_time_rpt_struct
3075: WHERE report_date = l_As_Of_Date
3076: AND bitand(record_type_id,1143) = record_type_id
3077: AND calendar_id = l_Calendar_Id;
3078: END IF;

Line 3096: FROM fii_time_rpt_struct

3092: ELSE
3093: INSERT INTO PJI_PMV_ITD_DIM_TMP
3094: (PRIOR_ID, NAME, ORDER_BY_ID, PERIOD_TYPE, COMPARATOR_TYPE, CALENDAR_TYPE)
3095: SELECT time_id, '-1', '-1', period_type_id, p_Comparator, calendar_type
3096: FROM fii_time_rpt_struct
3097: WHERE report_date = l_Prior_As_Of_Date
3098: AND bitand(record_type_id,1143) = record_type_id
3099: AND calendar_id = l_Calendar_Id;
3100: END IF;

Line 3439: FROM fii_time_rpt_struct

3435: ELSE
3436: INSERT INTO PJI_PMV_TIME_DIM_TMP
3437: (ID, NAME, ORDER_BY_ID, PERIOD_TYPE, AMOUNT_TYPE, CALENDAR_TYPE)
3438: SELECT time_id, l_Def_View_BY, l_Def_View_BY_ID, period_type_id, 1 , calendar_type
3439: FROM fii_time_rpt_struct
3440: WHERE report_date = l_As_Of_Date
3441: AND bitand(record_type_id,l_Level) = record_type_id
3442: AND calendar_id = l_Calendar_Id;
3443: END IF;

Line 3461: FROM fii_time_rpt_struct

3457: ELSE
3458: INSERT INTO PJI_PMV_TIME_DIM_TMP
3459: (PRIOR_ID, NAME, ORDER_BY_ID, PERIOD_TYPE, AMOUNT_TYPE, CALENDAR_TYPE)
3460: SELECT time_id, l_Def_View_BY, l_Def_View_BY_ID, period_type_id, 1, calendar_type
3461: FROM fii_time_rpt_struct
3462: WHERE report_date = l_Prior_As_Of_Date
3463: AND bitand(record_type_id,l_Level) = record_type_id
3464: AND calendar_id = l_Calendar_Id;
3465: END IF;