APPS.FII_RECONVERSION_PKG dependencies on FII_TIME_DAY

Line 382: FROM FII_TIME_DAY

378: -- Validate the passed From Date which is defined in the global calendar
379: l_process_step := 'VALIDATE_FROM_DATE';
380: BEGIN
381: SELECT report_date_julian INTO l_from_date_id
382: FROM FII_TIME_DAY
383: WHERE report_date = l_from_date;
384: EXCEPTION
385: WHEN NO_DATA_FOUND THEN
386: -- From Date is not defined in the calendar

Line 398: FROM FII_TIME_DAY

394: -- Validate the passed To Date which is defined in the global calendar
395: l_process_step := 'VALIDATE_TO_DATE';
396: BEGIN
397: SELECT report_date_julian INTO l_to_date_id
398: FROM FII_TIME_DAY
399: WHERE report_date = l_to_date;
400: EXCEPTION
401: WHEN NO_DATA_FOUND THEN
402: -- To Date is not defined in the calendar

Line 842: FROM FII_TIME_DAY t, GL_LEDGERS_PUBLIC_V sob

838: , t.report_date, p_primary_rate_type))
839: , DECODE( p_secondary_currency, sob.currency_code, 1, NULL, NULL
840: , FII_CURRENCY.GET_RATE( sob.currency_code, p_secondary_currency
841: , t.report_date, p_secondary_rate_type))
842: FROM FII_TIME_DAY t, GL_LEDGERS_PUBLIC_V sob
843: WHERE t.report_date_julian BETWEEN p_from_date_id and p_to_date_id
844: AND EXISTS (SELECT 'This date has GL transaction'
845: FROM FII_GL_JE_SUMMARY_B gl
846: WHERE gl.time_id = t.report_date_julian

Line 889: FROM FII_TIME_DAY t, GL_LEDGERS_PUBLIC_V sob

885: , t.report_date, p_primary_rate_type))
886: , DECODE( p_secondary_currency, sob.currency_code, 1, NULL, NULL
887: , FII_CURRENCY.GET_RATE( sob.currency_code, p_secondary_currency
888: , t.report_date, p_secondary_rate_type))
889: FROM FII_TIME_DAY t, GL_LEDGERS_PUBLIC_V sob
890: WHERE t.report_date_julian BETWEEN p_from_date_id and p_to_date_id
891: AND EXISTS (SELECT /*+ parallel(ap) */ 'This date has AP transaction'
892: FROM FII_AP_INV_B ap
893: WHERE ap.account_date_id = t.report_date_julian

Line 938: FROM FII_TIME_DAY t, GL_LEDGERS_PUBLIC_V sob

934: , t.report_date, p_primary_rate_type))
935: , DECODE( p_secondary_currency, sob.currency_code, 1, NULL, NULL
936: , FII_CURRENCY.GET_RATE( sob.currency_code, p_secondary_currency
937: , t.report_date, p_secondary_rate_type))
938: FROM FII_TIME_DAY t, GL_LEDGERS_PUBLIC_V sob
939: WHERE t.report_date_julian BETWEEN p_from_date_id and p_to_date_id
940: AND EXISTS (SELECT /*+ parallel(ar) */ 'This date has AR transaction'
941: FROM FII_AR_REVENUE_B ar
942: WHERE ar.gl_date_id = t.report_date_julian

Line 1367: l_processSQL(i) := ' FROM FII_RECONV_GL_ROLLUP_GT g, FII_TIME_DAY t';

1363:
1364: -- FROM clause
1365: l_process_step := 'BUILD_WEEKLY_SQL_FROM';
1366: i := i + 1;
1367: l_processSQL(i) := ' FROM FII_RECONV_GL_ROLLUP_GT g, FII_TIME_DAY t';
1368:
1369: -- WHERE clauses
1370: l_process_step := 'BUILD_WEEKLY_SQL_WHERE';
1371: i := i + 1;

Line 1507: l_processSQL(i) := ' FROM FII_RECONV_GL_ROLLUP_GT g, FII_TIME_DAY t';

1503:
1504: -- FROM clause
1505: l_process_step := 'BUILD_OTHER_SQL_FROM';
1506: i := i + 1;
1507: l_processSQL(i) := ' FROM FII_RECONV_GL_ROLLUP_GT g, FII_TIME_DAY t';
1508:
1509: -- WHERE clauses
1510: l_process_step := 'BUILD_OTHER_SQL_WHERE';
1511: i := i + 1;