DBA Data[Home] [Help]

APPS.IGS_AS_DOC_DETAILS_PKG dependencies on IGS_LOOKUPS_VIEW

Line 2658: FROM igs_lookups_view lkup

2654: ) THEN
2655: DECLARE
2656: CURSOR cur_document_type (cp_document_type IN VARCHAR2) IS
2657: SELECT lkup.meaning
2658: FROM igs_lookups_view lkup
2659: WHERE lkup.lookup_type = 'IGS_AS_DOCUMENT_TYPE'
2660: AND lkup.lookup_code = cp_document_type;
2661: CURSOR cur_document_sub_type (cp_document_sub_type IN VARCHAR2) IS
2662: SELECT lkup.meaning

Line 2663: FROM igs_lookups_view lkup

2659: WHERE lkup.lookup_type = 'IGS_AS_DOCUMENT_TYPE'
2660: AND lkup.lookup_code = cp_document_type;
2661: CURSOR cur_document_sub_type (cp_document_sub_type IN VARCHAR2) IS
2662: SELECT lkup.meaning
2663: FROM igs_lookups_view lkup
2664: WHERE lkup.lookup_type = 'IGS_AS_DOCUMENT_SUB_TYPE'
2665: AND lkup.lookup_code = cp_document_sub_type;
2666: CURSOR cur_delivery_method (cp_delivery_method_type IN VARCHAR2) IS
2667: SELECT description