APPS.GMS_AWARD_PVT dependencies on PA_PERIODS

Line 1351: select count(*) from pa_periods pap

1347: AND a.primary_flag = 'Y'
1348: AND a.assignment_type = 'E';
1349:
1350: cursor c_pa_period(x_date date) is
1351: select count(*) from pa_periods pap
1352: where x_date between pap.start_date and pap.end_date ;
1353:
1354: cursor c_gl_period(x_date date) is
1355: select 1

Line 1550: -- ++++++++++ Check PA periods ++++++++++++++++++

1546: add_message_to_stack( P_label => 'GMS_AGENCY_FORM_NULL' ) ;
1547: l_error := TRUE ;
1548: END IF ;
1549:
1550: -- ++++++++++ Check PA periods ++++++++++++++++++
1551: open C_pa_period(g_award_rec.start_date_active) ;
1552: fetch C_pa_period into x_dummy ;
1553: close c_pa_period ;
1554:

Line 1571: /* commented the close_date validation against open pa periods for bug 7603285*/

1567: l_error := TRUE ;
1568: END IF ;
1569:
1570: x_dummy := 0 ;
1571: /* commented the close_date validation against open pa periods for bug 7603285*/
1572: /*open C_pa_period(g_award_rec.close_date) ;
1573: fetch C_pa_period into x_dummy ;
1574: close c_pa_period ;
1575: IF x_dummy = 0 THEN