APPS.GMS_AWARD_PUB dependencies on PA_IND_RATE_SCHEDULES

Line 349: L_IDC_schedule_type pa_ind_rate_schedules.ind_rate_schedule_type%TYPE ;

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 ;
351:
352: L_award_rec GMS_AWARDS_ALL%ROWTYPE ;
353: L_award_id GMS_AWARDS_ALL.AWARD_ID%TYPE ;

Line 350: L_ind_rate_sch_id pa_ind_rate_schedules.ind_rate_sch_id%TYPE ;

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 ;
351:
352: L_award_rec GMS_AWARDS_ALL%ROWTYPE ;
353: L_award_id GMS_AWARDS_ALL.AWARD_ID%TYPE ;
354:

Line 380: FROM pa_ind_rate_schedules

376:
377: CURSOR C_IDC_SCH is
378: SELECT ind_rate_sch_id,
379: ind_rate_schedule_type
380: FROM pa_ind_rate_schedules
381: WHERE ind_rate_sch_name = P_INDIRECT_SCHEDULE ;
382:
383: BEGIN
384: G_stage := 'CREATE_AWARD_BEGINS' ;