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;
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