APPS.PA_FP_GEN_COMMITMENT_AMOUNTS dependencies on PA_PERIODS_ALL

Line 103: l_bl_period_name pa_periods_all.period_name%TYPE;

99: l_resource_class_id PA_RESOURCE_CLASSES_B.RESOURCE_CLASS_ID%TYPE;
100:
101: l_bl_start_date DATE;
102: l_bl_end_date DATE;
103: l_bl_period_name pa_periods_all.period_name%TYPE;
104: l_etc_start_date DATE;
105: l_reference_start_date DATE;
106: l_reference_end_date DATE;
107:

Line 735: FROM pa_periods_all pap

731: ,pap.period_name
732: INTO l_bl_start_date
733: ,l_bl_end_date
734: ,l_bl_period_name
735: FROM pa_periods_all pap
736: --,pa_implementations imp /* Bug 4884718; SQL ID 14901776 */
737: WHERE l_reference_start_date BETWEEN pap.start_date AND pap.end_date
738: AND pap.org_id = p_fp_cols_rec.x_org_id;
739: -- R12 MOAC 4447573: NVL(pap.org_id,-99)