APPS.PA_FP_GEN_COMMITMENT_AMOUNTS dependencies on GL_PERIOD_STATUSES

Line 20: ,c_appl_id GL_PERIOD_STATUSES.APPLICATION_ID%TYPE

16: l_module_name VARCHAR2(200) := 'pa.plsql.PA_FP_GEN_COMMITMENT_AMOUNTS.GEN_COMMITMENT_AMOUNTS';
17:
18: CURSOR SUM_COMM_CRSR( c_tphase PA_PROJ_FP_OPTIONS.COST_TIME_PHASED_CODE%TYPE
19: ,c_multi_curr_flag PA_PROJ_FP_OPTIONS.PLAN_IN_MULTI_CURR_FLAG%TYPE
20: ,c_appl_id GL_PERIOD_STATUSES.APPLICATION_ID%TYPE
21: ,c_set_of_books_id PA_IMPLEMENTATIONS_ALL.SET_OF_BOOKS_ID%TYPE
22: ,c_org_id PA_PROJECTS_ALL.ORG_ID%TYPE
23: )
24: IS

Line 754: FROM GL_PERIOD_STATUSES PERIOD

750: PERIOD.period_name
751: INTO l_bl_start_date
752: ,l_bl_end_date
753: ,l_bl_period_name
754: FROM GL_PERIOD_STATUSES PERIOD
755: WHERE PERIOD.application_id = pa_period_process_pkg.application_id
756: AND PERIOD.set_of_books_id = p_fp_cols_rec.x_set_of_books_id
757: AND PERIOD.adjustment_period_flag = 'N'
758: AND l_reference_start_date BETWEEN