APPS.PA_FP_GEN_PUB dependencies on PA_PERIOD_PROCESS_PKG

Line 1092: AND glp.application_id = pa_period_process_pkg.application_id

1088: INTO l_start_date,
1089: l_end_date
1090: FROM gl_period_statuses glp
1091: WHERE glp.period_name = p_unspent_amt_period
1092: AND glp.application_id = pa_period_process_pkg.application_id
1093: AND glp.set_of_books_id = p_fp_cols_rec.x_set_of_books_id
1094: AND glp.adjustment_period_flag = 'N';
1095: EXCEPTION
1096: WHEN OTHERS THEN RAISE;

Line 1614: WHERE application_id = PA_PERIOD_PROCESS_PKG.Application_id and

1610: CURSOR gl_period_csr(c_amt_thru PA_PERIODS_ALL.END_DATE%TYPE,
1611: c_set_of_books PA_IMPLEMENTATIONS_ALL.SET_OF_BOOKS_ID%TYPE) IS
1612: SELECT period_name, start_date , end_date
1613: FROM gl_period_statuses
1614: WHERE application_id = PA_PERIOD_PROCESS_PKG.Application_id and
1615: set_of_books_id = c_set_of_books and
1616: adjustment_period_flag = 'N' and
1617: c_amt_thru between start_date and end_date;
1618: gl_period_rec gl_period_csr%ROWTYPE;