APPS.GMS_AWARD_PUB dependencies on PA_BILLING_CYCLES

Line 355: L_billing_cycle_id pa_billing_cycles.billing_cycle_id%TYPE ;

351:
352: L_award_rec GMS_AWARDS_ALL%ROWTYPE ;
353: L_award_id GMS_AWARDS_ALL.AWARD_ID%TYPE ;
354:
355: L_billing_cycle_id pa_billing_cycles.billing_cycle_id%TYPE ;
356: L_fctrl_award gms_awards_all.fund_control_level_award%TYPE;
357: L_fctrl_task gms_awards_all.fund_control_level_task%TYPE;
358: L_fctrl_RGP gms_awards_all.fund_control_level_res_grp%TYPE;
359: L_fctrl_res gms_awards_all.fund_control_level_res%TYPE;

Line 367: FROM pa_billing_cycles

363:
364:
365: CURSOR C_BILL is
366: SELECT billing_cycle_id
367: FROM pa_billing_cycles
368: WHERE trunc(sysdate) between start_date_active
369: and NVL( end_date_active, sysdate )
370: and billing_cycle_name = P_BILLING_CYCLE ;
371: