APPS.PA_FP_GEN_COMMITMENT_AMOUNTS dependencies on PA_PERIODS_ALL

Line 102: l_bl_period_name pa_periods_all.period_name%TYPE;

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

Line 727: FROM pa_periods_all pap

723: ,pap.period_name
724: INTO l_bl_start_date
725: ,l_bl_end_date
726: ,l_bl_period_name
727: FROM pa_periods_all pap
728: --,pa_implementations imp /* Bug 4884718; SQL ID 14901776 */
729: WHERE l_reference_start_date BETWEEN pap.start_date AND pap.end_date
730: AND pap.org_id = p_fp_cols_rec.x_org_id;
731: -- R12 MOAC 4447573: NVL(pap.org_id,-99)