APPS.GMS_AWARD_PVT dependencies on PA_PERIODS

Line 1352: select count(*) from pa_periods pap

1348: -- AND a.assignment_type = 'E'; -- Bug 10124847
1349: AND a.assignment_type in ('C','E');
1350:
1351: cursor c_pa_period(x_date date) is
1352: select count(*) from pa_periods pap
1353: where x_date between pap.start_date and pap.end_date ;
1354:
1355: cursor c_gl_period(x_date date) is
1356: select 1

Line 1551: -- ++++++++++ Check PA periods ++++++++++++++++++

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

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

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