APPS.IGS_AS_DOCUMENTS_API dependencies on IGS_LOOKUPS_VIEW

Line 746: igs_lookups_view lkv

742: --
743: CURSOR cur_free_plan IS
744: SELECT 'Y'
745: FROM igs_as_servic_plan asp,
746: igs_lookups_view lkv
747: WHERE asp.plan_type = lkv.meaning
748: AND lkv.lookup_type = 'TRANSCRIPT_SERVICE_PLAN_TYPE'
749: AND lkv.lookup_code = 'FREE_TRANSCRIPT'
750: AND asp.plan_id = p_plan_id;