APPS.IGS_GR_PRC_GAC dependencies on IGS_AD_LOCATION_REL

Line 52: dflt_ind IGS_AD_LOCATION_REL.dflt_ind%TYPE);

48: award_crs_version_number
49: IGS_GR_AWD_CRM_US_GP.award_crs_version_number%TYPE,
50: award_cd IGS_GR_AWD_CRM_US_GP.award_cd%TYPE,
51: us_group_number IGS_GR_AWD_CRM_US_GP.us_group_number%TYPE,
52: dflt_ind IGS_AD_LOCATION_REL.dflt_ind%TYPE);
53: r_acusg_match r_acusg_match_typ;
54: TYPE t_acusg_match_typ IS TABLE OF r_acusg_match%TYPE
55: INDEX BY BINARY_INTEGER;
56: t_acusg_match t_acusg_match_typ;

Line 67: dflt_ind IGS_AD_LOCATION_REL.dflt_ind%TYPE);

63: ceremony_number IGS_GR_AWD_CEREMONY.ceremony_number%TYPE,
64: award_course_cd IGS_GR_AWD_CEREMONY.award_course_cd%TYPE,
65: award_crs_version_number IGS_GR_AWD_CEREMONY.award_crs_version_number%TYPE,
66: award_cd IGS_GR_AWD_CEREMONY.award_cd%TYPE,
67: dflt_ind IGS_AD_LOCATION_REL.dflt_ind%TYPE);
68: r_awc_match r_awc_match_typ;
69: TYPE t_awc_match_typ IS TABLE OF r_awc_match%TYPE
70: INDEX BY BINARY_INTEGER;
71: t_awc_match t_awc_match_typ;

Line 104: IGS_AD_LOCATION_REL lr,

100: IGS_GR_AWD_CEREMONY awc,
101: IGS_EN_STDNT_PS_ATT sca,
102: IGS_GR_CRMN gc,
103: IGS_GR_VENUE ve,
104: IGS_AD_LOCATION_REL lr,
105: IGS_CA_DA_INST_V daiv
106: WHERE gr.person_id = p_person_id AND
107: gr.create_dt = p_create_dt AND
108: gr.grd_cal_type = p_grd_cal_type AND