DBA Data[Home] [Help]

APPS.PQH_FR_SPEED dependencies on PQH_CORPS_DEFINITIONS

Line 259: FROM pqh_corps_definitions corps

255: --Cursor to fetch Speed Quota for the specified Corps and Grade
256: CURSOR csr_speed_quota IS
257: SELECT NVL(cei.information6,-1) --MAX Speed Quota
258: ,NVL(cei.information7,-1) --AVG Speed Quota
259: FROM pqh_corps_definitions corps
260: ,pqh_corps_extra_info cei
261: WHERE corps.ben_pgm_id = p_ben_pgm_id
262: AND cei.corps_definition_id = corps.corps_definition_id
263: AND cei.information3 = TO_CHAR(p_grade_id)