APPS.FII_PSI_JE_DTL_PKG dependencies on FII_TIME_DAY

Line 37: FROM fii_time_day

33: l_fud1_where := REPLACE(fii_ea_util_pkg.get_fud1_for_detail, 'fud1_id', 'user_dim1_id');
34: l_fud2_where := REPLACE(fii_ea_util_pkg.get_fud2_for_detail, 'fud2_id', 'user_dim2_id');
35:
36: SELECT report_date_julian INTO fii_ea_util_pkg.g_curr_per_start_id
37: FROM fii_time_day
38: WHERE report_date = fii_ea_util_pkg.g_curr_per_start;
39:
40: SELECT report_date_julian INTO fii_ea_util_pkg.g_as_of_date_id
41: FROM fii_time_day

Line 41: FROM fii_time_day

37: FROM fii_time_day
38: WHERE report_date = fii_ea_util_pkg.g_curr_per_start;
39:
40: SELECT report_date_julian INTO fii_ea_util_pkg.g_as_of_date_id
41: FROM fii_time_day
42: WHERE report_date = fii_ea_util_pkg.g_as_of_date;
43:
44: /* For a Purchase Order, gl_je_lines.reference_2 and gl_je_lines.reference_4 store po_header_id and po_number respectively.
45: We join between gl_je_lines and po_distributions_all on po_header_id to fetch po_release_id (to be passed in PO drill).