APPS.PA_FP_GEN_PUB dependencies on GL_PERIOD_STATUSES

Line 1103: FROM gl_period_statuses glp

1099: SELECT glp.start_date,
1100: glp.end_date
1101: INTO l_start_date,
1102: l_end_date
1103: FROM gl_period_statuses glp
1104: WHERE glp.period_name = p_unspent_amt_period
1105: AND glp.application_id = pa_period_process_pkg.application_id
1106: AND glp.set_of_books_id = p_fp_cols_rec.x_set_of_books_id
1107: AND glp.adjustment_period_flag = 'N';

Line 1626: FROM gl_period_statuses

1622: --Cursor used to select the GL period that contains the amts_thru_date and later
1623: CURSOR gl_period_csr(c_amt_thru PA_PERIODS_ALL.END_DATE%TYPE,
1624: c_set_of_books PA_IMPLEMENTATIONS_ALL.SET_OF_BOOKS_ID%TYPE) IS
1625: SELECT period_name, start_date , end_date
1626: FROM gl_period_statuses
1627: WHERE application_id = PA_PERIOD_PROCESS_PKG.Application_id and
1628: set_of_books_id = c_set_of_books and
1629: adjustment_period_flag = 'N' and
1630: c_amt_thru between start_date and end_date;