DBA Data[Home] [Help]

APPS.PQH_FR_SPEED dependencies on PQH_CORPS_EXTRA_INFO

Line 260: ,pqh_corps_extra_info cei

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)
264: AND cei.information_type = 'GRADE';