APPS.PA_FUNDS_CONTROL_PKG1 dependencies on PA_PERIODS

Line 7671: FROM pa_periods gpa

7667: SELECT TRUNC ( start_date ),
7668: TRUNC ( end_date )
7669: INTO l_pa_period_start_date,
7670: l_pa_period_end_date
7671: FROM pa_periods gpa
7672: WHERE p_expenditure_item_date BETWEEN gpa.start_date AND gpa.end_date;
7673:
7674: PA_FUNDS_CONTROL_PKG.log_message(p_msg_token1 =>'l_pa_period_start_date is = '||l_pa_period_start_date);
7675: PA_FUNDS_CONTROL_PKG.log_message(p_msg_token1 =>'l_pa_period_end_date is = '||l_pa_period_end_date);

Line 7729: FROM pa_periods gpa

7725: PA_FUNDS_CONTROL_PKG.log_message(p_msg_token1 =>' PJTD- P');
7726: BEGIN
7727: SELECT TRUNC ( start_date )
7728: INTO l_gs_start_date
7729: FROM pa_periods gpa
7730: WHERE l_project_start_date BETWEEN gpa.start_date AND gpa.end_date;
7731: PA_FUNDS_CONTROL_PKG.log_message(p_msg_token1 =>'l_gs_start_date is = '||l_gs_start_date);
7732:
7733: EXCEPTION

Line 7792: FROM pa_periods gpa

7788: PA_FUNDS_CONTROL_PKG.log_message(p_msg_token1 =>'PJTD_J-P');
7789: BEGIN
7790: SELECT TRUNC ( end_date )
7791: INTO l_gs_end_date
7792: FROM pa_periods gpa
7793: WHERE l_project_end_date BETWEEN gpa.start_date AND gpa.end_date;
7794: PA_FUNDS_CONTROL_PKG.log_message(p_msg_token1 =>'l_gs_end_date is = '||l_gs_end_date);
7795: EXCEPTION
7796: WHEN NO_DATA_FOUND THEN

Line 7851: FROM pa_periods p

7847: PA_FUNDS_CONTROL_PKG.log_message(p_msg_token1 =>'PJTD-Y-P');
7848: BEGIN
7849: SELECT p.end_date
7850: INTO l_gs_end_date
7851: FROM pa_periods p
7852: WHERE l_year_end_date BETWEEN p.start_date AND p.end_date;
7853: x_end_date := l_gs_end_date;
7854: PA_FUNDS_CONTROL_PKG.log_message(p_msg_token1 =>'l_gs_end_date is = '||l_gs_end_date);
7855: EXCEPTION

Line 7903: FROM pa_periods p

7899: PA_FUNDS_CONTROL_PKG.log_message(p_msg_token1 =>'YTD1-P');
7900: BEGIN
7901: SELECT p.start_date
7902: INTO l_gs_start_date
7903: FROM pa_periods p
7904: WHERE l_year_start_date BETWEEN p.start_date AND p.end_date;
7905: x_start_date := l_gs_start_date;
7906: EXCEPTION
7907: WHEN NO_DATA_FOUND THEN

Line 7933: FROM pa_periods p

7929: (p_msg_token1 =>'YTD-Y-P');
7930: BEGIN
7931: SELECT p.end_date
7932: INTO l_gs_end_date
7933: FROM pa_periods p
7934: WHERE l_year_end_date BETWEEN p.start_date AND p.end_date;
7935: x_end_date := l_gs_end_date;
7936: EXCEPTION
7937: WHEN NO_DATA_FOUND THEN