APPS.FV_RECEIVABLES_ACTIVITY_PKG dependencies on GL_PERIOD_STATUSES

Line 109: FROM gl_period_statuses

105: -- Deriving the End Date for the period for which Report is being run
106: BEGIN
107: SELECT MIN(start_date) , MAX(end_date)
108: INTO vl_fy_begin_date , vl_fy_end_date
109: FROM gl_period_statuses
110: WHERE period_year = p_fiscal_year
111: AND set_of_books_id = P_SET_OF_BOOKS_ID
112: AND application_id = '101';
113: EXCEPTION

Line 129: FROM gl_period_statuses

125: BEGIN
126: IF P_QUARTER IS NOT NULL THEN
127: SELECT MAX (end_date)
128: INTO vg_end_date
129: FROM gl_period_statuses
130: WHERE period_year = P_FISCAL_YEAR
131: AND set_of_books_id = vp_sob_id
132: AND application_id = '101'
133: AND quarter_num = P_QUARTER;