DBA Data[Home] [Help]

APPS.GR_PROCESS_DOCUMENTS dependencies on GR_SUB_HEADINGS_TL

Line 106: G_INGCASNUM_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;

102: */
103: /*
104: ** Global Column Headings
105: */
106: G_INGCASNUM_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
107: G_INGMSDS_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
108: G_INGCONC_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
109: G_INGUSER_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
110: G_INGEEC_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;

Line 107: G_INGMSDS_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;

103: /*
104: ** Global Column Headings
105: */
106: G_INGCASNUM_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
107: G_INGMSDS_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
108: G_INGCONC_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
109: G_INGUSER_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
110: G_INGEEC_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
111: G_INGHAZARD_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;

Line 108: G_INGCONC_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;

104: ** Global Column Headings
105: */
106: G_INGCASNUM_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
107: G_INGMSDS_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
108: G_INGCONC_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
109: G_INGUSER_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
110: G_INGEEC_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
111: G_INGHAZARD_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
112: G_INGNFPA_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;

Line 109: G_INGUSER_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;

105: */
106: G_INGCASNUM_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
107: G_INGMSDS_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
108: G_INGCONC_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
109: G_INGUSER_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
110: G_INGEEC_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
111: G_INGHAZARD_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
112: G_INGNFPA_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
113: G_INGHMIS_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;

Line 110: G_INGEEC_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;

106: G_INGCASNUM_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
107: G_INGMSDS_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
108: G_INGCONC_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
109: G_INGUSER_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
110: G_INGEEC_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
111: G_INGHAZARD_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
112: G_INGNFPA_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
113: G_INGHMIS_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
114: G_INGRISK_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;

Line 111: G_INGHAZARD_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;

107: G_INGMSDS_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
108: G_INGCONC_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
109: G_INGUSER_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
110: G_INGEEC_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
111: G_INGHAZARD_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
112: G_INGNFPA_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
113: G_INGHMIS_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
114: G_INGRISK_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
115: G_INGSAFETY_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;

Line 112: G_INGNFPA_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;

108: G_INGCONC_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
109: G_INGUSER_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
110: G_INGEEC_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
111: G_INGHAZARD_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
112: G_INGNFPA_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
113: G_INGHMIS_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
114: G_INGRISK_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
115: G_INGSAFETY_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
116: G_EXPCASNUM_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;

Line 113: G_INGHMIS_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;

109: G_INGUSER_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
110: G_INGEEC_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
111: G_INGHAZARD_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
112: G_INGNFPA_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
113: G_INGHMIS_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
114: G_INGRISK_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
115: G_INGSAFETY_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
116: G_EXPCASNUM_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
117: G_EXPMSDS_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;

Line 114: G_INGRISK_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;

110: G_INGEEC_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
111: G_INGHAZARD_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
112: G_INGNFPA_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
113: G_INGHMIS_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
114: G_INGRISK_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
115: G_INGSAFETY_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
116: G_EXPCASNUM_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
117: G_EXPMSDS_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
118: G_EXPAUTH_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;

Line 115: G_INGSAFETY_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;

111: G_INGHAZARD_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
112: G_INGNFPA_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
113: G_INGHMIS_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
114: G_INGRISK_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
115: G_INGSAFETY_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
116: G_EXPCASNUM_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
117: G_EXPMSDS_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
118: G_EXPAUTH_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
119: G_EXPTYPE_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;

Line 116: G_EXPCASNUM_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;

112: G_INGNFPA_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
113: G_INGHMIS_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
114: G_INGRISK_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
115: G_INGSAFETY_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
116: G_EXPCASNUM_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
117: G_EXPMSDS_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
118: G_EXPAUTH_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
119: G_EXPTYPE_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
120: G_EXPDOSE_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;

Line 117: G_EXPMSDS_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;

113: G_INGHMIS_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
114: G_INGRISK_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
115: G_INGSAFETY_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
116: G_EXPCASNUM_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
117: G_EXPMSDS_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
118: G_EXPAUTH_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
119: G_EXPTYPE_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
120: G_EXPDOSE_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
121: G_EXPNOTE_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;

Line 118: G_EXPAUTH_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;

114: G_INGRISK_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
115: G_INGSAFETY_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
116: G_EXPCASNUM_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
117: G_EXPMSDS_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
118: G_EXPAUTH_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
119: G_EXPTYPE_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
120: G_EXPDOSE_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
121: G_EXPNOTE_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
122: G_TOXCASNUM_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;

Line 119: G_EXPTYPE_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;

115: G_INGSAFETY_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
116: G_EXPCASNUM_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
117: G_EXPMSDS_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
118: G_EXPAUTH_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
119: G_EXPTYPE_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
120: G_EXPDOSE_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
121: G_EXPNOTE_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
122: G_TOXCASNUM_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
123: G_TOXMSDS_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;

Line 120: G_EXPDOSE_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;

116: G_EXPCASNUM_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
117: G_EXPMSDS_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
118: G_EXPAUTH_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
119: G_EXPTYPE_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
120: G_EXPDOSE_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
121: G_EXPNOTE_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
122: G_TOXCASNUM_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
123: G_TOXMSDS_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
124: G_TOXSPECIES_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;

Line 121: G_EXPNOTE_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;

117: G_EXPMSDS_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
118: G_EXPAUTH_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
119: G_EXPTYPE_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
120: G_EXPDOSE_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
121: G_EXPNOTE_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
122: G_TOXCASNUM_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
123: G_TOXMSDS_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
124: G_TOXSPECIES_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
125: G_TOXEXPOSE_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;

Line 122: G_TOXCASNUM_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;

118: G_EXPAUTH_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
119: G_EXPTYPE_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
120: G_EXPDOSE_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
121: G_EXPNOTE_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
122: G_TOXCASNUM_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
123: G_TOXMSDS_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
124: G_TOXSPECIES_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
125: G_TOXEXPOSE_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
126: G_TOXROUTE_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;

Line 123: G_TOXMSDS_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;

119: G_EXPTYPE_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
120: G_EXPDOSE_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
121: G_EXPNOTE_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
122: G_TOXCASNUM_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
123: G_TOXMSDS_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
124: G_TOXSPECIES_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
125: G_TOXEXPOSE_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
126: G_TOXROUTE_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
127: G_TOXDOSE_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;

Line 124: G_TOXSPECIES_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;

120: G_EXPDOSE_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
121: G_EXPNOTE_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
122: G_TOXCASNUM_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
123: G_TOXMSDS_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
124: G_TOXSPECIES_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
125: G_TOXEXPOSE_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
126: G_TOXROUTE_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
127: G_TOXDOSE_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
128: G_TOXNOTE_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;

Line 125: G_TOXEXPOSE_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;

121: G_EXPNOTE_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
122: G_TOXCASNUM_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
123: G_TOXMSDS_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
124: G_TOXSPECIES_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
125: G_TOXEXPOSE_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
126: G_TOXROUTE_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
127: G_TOXDOSE_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
128: G_TOXNOTE_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
129: G_PRINT_COL_HDG VARCHAR2(1);

Line 126: G_TOXROUTE_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;

122: G_TOXCASNUM_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
123: G_TOXMSDS_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
124: G_TOXSPECIES_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
125: G_TOXEXPOSE_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
126: G_TOXROUTE_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
127: G_TOXDOSE_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
128: G_TOXNOTE_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
129: G_PRINT_COL_HDG VARCHAR2(1);
130:

Line 127: G_TOXDOSE_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;

123: G_TOXMSDS_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
124: G_TOXSPECIES_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
125: G_TOXEXPOSE_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
126: G_TOXROUTE_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
127: G_TOXDOSE_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
128: G_TOXNOTE_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
129: G_PRINT_COL_HDG VARCHAR2(1);
130:
131: /*

Line 128: G_TOXNOTE_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;

124: G_TOXSPECIES_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
125: G_TOXEXPOSE_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
126: G_TOXROUTE_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
127: G_TOXDOSE_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
128: G_TOXNOTE_HDG GR_SUB_HEADINGS_TL.sub_heading_desc%TYPE;
129: G_PRINT_COL_HDG VARCHAR2(1);
130:
131: /*
132: ** Global numeric variable definitions

Line 266: FROM gr_sub_headings_tl sht,

262: IS
263: SELECT shb.sub_heading_print_font,
264: shb.sub_heading_print_size,
265: sht.sub_heading_desc
266: FROM gr_sub_headings_tl sht,
267: gr_sub_headings_b shb
268: WHERE shb.sub_heading_code = g_sub_heading
269: AND sht.sub_heading_code = g_sub_heading
270: AND sht.language = g_language_code;