APPS.QA_SSQR_JRAD_PKG dependencies on QA_PLAN_CHAR_VALUE_LOOKUPS

Line 3392: FROM qa_plan_char_value_lookups

3388: WHERE plan_id = p_plan_id;
3389:
3390: CURSOR valueLookups(c_char_id NUMBER) IS
3391: SELECT short_code, ORA_HASH(short_code) hash_code
3392: FROM qa_plan_char_value_lookups
3393: WHERE plan_id = p_plan_id
3394: AND char_id = c_char_id;
3395:
3396: l_template_plan_id NUMBER;

Line 3397: l_short_code qa_plan_char_value_lookups.short_code%TYPE;

3393: WHERE plan_id = p_plan_id
3394: AND char_id = c_char_id;
3395:
3396: l_template_plan_id NUMBER;
3397: l_short_code qa_plan_char_value_lookups.short_code%TYPE;
3398: l_hash_code NUMBER;
3399: BEGIN
3400: OPEN plan;
3401: FETCH plan INTO l_template_plan_id;