DBA Data[Home] [Help]

APPS.IGS_AS_SS_DOC_REQUEST dependencies on IGS_AS_DOC_DLVY_TYP

Line 1543: FROM igs_as_doc_dlvy_typ

1539: ) AS
1540: -- To select the delivery method type:
1541: CURSOR c_deliv_type IS
1542: SELECT delivery_method_type
1543: FROM igs_as_doc_dlvy_typ
1544: WHERE s_delivery_method_type = 'MANUAL'
1545: AND closed_ind = 'Y'
1546: AND delivery_method_type = 'NONE';
1547: ldeliv_type igs_as_doc_dlvy_typ.delivery_method_type%TYPE;

Line 1547: ldeliv_type igs_as_doc_dlvy_typ.delivery_method_type%TYPE;

1543: FROM igs_as_doc_dlvy_typ
1544: WHERE s_delivery_method_type = 'MANUAL'
1545: AND closed_ind = 'Y'
1546: AND delivery_method_type = 'NONE';
1547: ldeliv_type igs_as_doc_dlvy_typ.delivery_method_type%TYPE;
1548: -- To get the document fee setup details
1549: -- for the given document type.
1550: CURSOR cur_doc_setup IS
1551: SELECT dfs.amount amount