eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQH_FR_QUOTA_CHECK dependencies on PQH_CORPS_EXTRA_INFO

Line 187: From pqh_corps_extra_info

183: Cursor grade_condition is
184: Select Information4 Percentage,
185: Information8 cond_type,
186: Information30 Grade_ids
187: From pqh_corps_extra_info
188: Where corps_definition_id = p_corp_id
189: And information3 = p_grade_id
190: And information_type = 'GRADE';
191:

Line 192: l_percentage pqh_corps_extra_info.information30%type;

188: Where corps_definition_id = p_corp_id
189: And information3 = p_grade_id
190: And information_type = 'GRADE';
191:
192: l_percentage pqh_corps_extra_info.information30%type;
193: l_cond_type pqh_corps_extra_info.information30%type;
194: l_grade_ids pqh_corps_extra_info.information30%type;
195: l_Quota_occupancy number;
196: l_corps_population number;

Line 193: l_cond_type pqh_corps_extra_info.information30%type;

189: And information3 = p_grade_id
190: And information_type = 'GRADE';
191:
192: l_percentage pqh_corps_extra_info.information30%type;
193: l_cond_type pqh_corps_extra_info.information30%type;
194: l_grade_ids pqh_corps_extra_info.information30%type;
195: l_Quota_occupancy number;
196: l_corps_population number;
197: l_grades_population number;

Line 194: l_grade_ids pqh_corps_extra_info.information30%type;

190: And information_type = 'GRADE';
191:
192: l_percentage pqh_corps_extra_info.information30%type;
193: l_cond_type pqh_corps_extra_info.information30%type;
194: l_grade_ids pqh_corps_extra_info.information30%type;
195: l_Quota_occupancy number;
196: l_corps_population number;
197: l_grades_population number;
198: l_start number;