APPS.GMS_AWARD_PUB dependencies on GMS_ALLOWABILITY_SCHEDULES

Line 346: L_allow_schedule_id gms_allowability_schedules.allowability_schedule_id%TYPE ;

342: P_PROPOSAL_ID IN NUMBER ) IS
343:
344:
345: l_api_name varchar2(30) := 'GMS_AWARD_PUB.CREATE_AWARD';
346: L_allow_schedule_id gms_allowability_schedules.allowability_schedule_id%TYPE ;
347: L_error BOOLEAN := FALSE ;
348:
349: L_IDC_schedule_type pa_ind_rate_schedules.ind_rate_schedule_type%TYPE ;
350: L_ind_rate_sch_id pa_ind_rate_schedules.ind_rate_sch_id%TYPE ;

Line 374: FROM gms_allowability_schedules

370: and billing_cycle_name = P_BILLING_CYCLE ;
371:
372: CURSOR C_allowable_sch is
373: SELECT allowability_schedule_id
374: FROM gms_allowability_schedules
375: WHERE allow_sch_name = P_ALLOWABLE_SCHEDULE ;
376:
377: CURSOR C_IDC_SCH is
378: SELECT ind_rate_sch_id,