APPS.BIL_BI_FST_DTL_F_PKG dependencies on FII_TIME_ENT_PERIOD

Line 1964: WHEN g_map_ent_per_type = 'FII_TIME_ENT_PERIOD' THEN

1960: BEGIN
1961: NULL;
1962: END;
1963:
1964: WHEN g_map_ent_per_type = 'FII_TIME_ENT_PERIOD' THEN
1965: BEGIN
1966: l_select := '
1967: Txn_Day
1968: ,Txn_Week

Line 1990: l_FROM := ' FROM BIL_BI_FST_DTL_STG stg, FII_TIME_ENT_Period fep';

1986: PRODUCT_CATEGORY_ID,
1987: CREDIT_TYPE_ID';
1988:
1989: l_rollup := ' grouping sets (fep.ENT_Year_ID, fep.ENT_Qtr_ID)';
1990: l_FROM := ' FROM BIL_BI_FST_DTL_STG stg, FII_TIME_ENT_Period fep';
1991: l_WHERE := ' WHERE stg.FORECAST_PERIOD_Period = fep.ENT_PERIOD_ID ';
1992: END;
1993:
1994: WHEN g_map_ent_per_type = 'FII_TIME_ENT_QTR' THEN

Line 2033: IF g_map_ent_per_type = 'FII_TIME_ENT_PERIOD' or

2029: END;
2030: END CASE;
2031:
2032:
2033: IF g_map_ent_per_type = 'FII_TIME_ENT_PERIOD' or
2034: g_map_ent_per_type = 'FII_TIME_ENT_QTR' THEN
2035:
2036: IF (g_mode='INITIAL') THEN
2037: l_stmt := ' INSERT /*+ PARALLEL(stg1) */ into BIL_BI_FST_DTL_STG stg1 (';

Line 2625: WHEN g_map_ent_per_type = 'FII_TIME_ENT_PERIOD' THEN

2621: glp.period_type = g_fsct_per_type );
2622:
2623: END;
2624:
2625: WHEN g_map_ent_per_type = 'FII_TIME_ENT_PERIOD' THEN
2626: BEGIN
2627:
2628: update BIL_BI_FST_DTL_STG stg set valid_flag = 'F' WHERE
2629: not exists

Line 2632: FII_TIME_ENT_PERIOD fep

2628: update BIL_BI_FST_DTL_STG stg set valid_flag = 'F' WHERE
2629: not exists
2630: (select '1' FROM
2631: gl_periods glp,
2632: FII_TIME_ENT_PERIOD fep
2633: WHERE
2634: fep.start_date = glp.start_date and
2635: fep.end_date = glp.end_date and
2636: glp.period_set_name = g_cal and

Line 2811: WHEN g_map_ent_per_type = 'FII_TIME_ENT_PERIOD' THEN

2807:
2808: END CASE;
2809:
2810:
2811: WHEN g_map_ent_per_type = 'FII_TIME_ENT_PERIOD' THEN
2812:
2813: CASE WHEN g_mode='INITIAL' OR g_first_run THEN
2814:
2815: UPDATE /*+ parallel(stg) */ BIL_BI_FST_DTL_STG stg set stg.FORECAST_PERIOD_PERIOD

Line 2816: = (SELECT fep.ent_period_id FROM FII_TIME_ENT_PERIOD fep,gl_periods glp

2812:
2813: CASE WHEN g_mode='INITIAL' OR g_first_run THEN
2814:
2815: UPDATE /*+ parallel(stg) */ BIL_BI_FST_DTL_STG stg set stg.FORECAST_PERIOD_PERIOD
2816: = (SELECT fep.ent_period_id FROM FII_TIME_ENT_PERIOD fep,gl_periods glp
2817: WHERE
2818: fep.start_date = glp.start_date and
2819: fep.end_date = glp.end_date and
2820: glp.period_set_name = g_cal and

Line 2828: = (select fep.ent_period_id FROM FII_TIME_ENT_PERIOD fep , gl_periods glp

2824:
2825: ELSE
2826:
2827: UPDATE BIL_BI_FST_DTL_STG stg set stg.FORECAST_PERIOD_PERIOD
2828: = (select fep.ent_period_id FROM FII_TIME_ENT_PERIOD fep , gl_periods glp
2829: WHERE
2830: fep.start_date = glp.start_date and
2831: fep.end_date = glp.end_date and
2832: glp.period_set_name = g_cal and