APPS.FII_GL_JE_B_C dependencies on FII_TIME_DAY

Line 789: -- time records which does not exist in FII_TIME_DAY

785: end if;
786:
787: -----------------------------------------------------------
788: -- If we find record in the staging table which references
789: -- time records which does not exist in FII_TIME_DAY
790: -- table, then we will exit the program with error status
791: -----------------------------------------------------------
792:
793: FII_TIME_API.check_missing_date (l_stg_min, l_stg_max, l_check_time_dim);

Line 941: fii_time_day fday

937: stg.creation_date,
938: stg.created_by,
939: stg.last_update_login
940: FROM fii_gl_je_summary_stg stg,
941: fii_time_day fday
942: WHERE stg.day = fday.report_date_julian
943: GROUP BY
944: stg.cost_center_id,
945: stg.fin_category_id,

Line 1092: fii_time_day fday

1088: stg.creation_date,
1089: stg.created_by,
1090: stg.last_update_login
1091: FROM fii_gl_je_summary_stg stg,
1092: fii_time_day fday
1093: WHERE stg.day = fday.report_date_julian
1094: GROUP BY
1095: stg.cost_center_id,
1096: stg.fin_category_id,

Line 2237: fii_time_day fday

2233: bsum.creation_date,
2234: bsum.created_by,
2235: bsum.last_update_login
2236: FROM fii_gl_je_summary_b bsum,
2237: fii_time_day fday
2238: WHERE bsum.time_id = fday.report_date_julian
2239: GROUP BY
2240: bsum.cost_center_id,
2241: bsum.fin_category_id,

Line 2371: fii_time_day fday

2367: bsum.creation_date,
2368: bsum.created_by,
2369: bsum.last_update_login
2370: FROM fii_gl_je_summary_b bsum,
2371: fii_time_day fday
2372: WHERE bsum.time_id = fday.report_date_julian
2373: GROUP BY
2374: bsum.cost_center_id,
2375: bsum.fin_category_id,

Line 3145: ' fii_time_day fday '||

3141: ' t.posted_date, t.last_update_date, '||
3142: ' t.last_updated_by, t.creation_date, t.created_by, '||
3143: ' t.last_update_login '||
3144: ' FROM fii_gl_enc_carryfwd_t t, '||
3145: ' fii_time_day fday '||
3146: ' WHERE t.day = fday.report_date_julian '||
3147: ' AND t.functional_currency = :global_primary '||
3148: ' GROUP BY t.company_id, t.cost_center_id, t.fin_category_id, '||
3149: ' t.prod_category_id, t.user_dim1_id, t.user_dim2_id, '||