APPS.IGS_AS_SS_DOC_REQUEST dependencies on IGS_AS_DOC_FEE_STUP

Line 400: FROM igs_as_doc_fee_stup dfs

396: SELECT dfs.lower_range lower_range,
397: dfs.upper_range upper_range,
398: dfs.payment_type payment_type,
399: dfs.amount amount
400: FROM igs_as_doc_fee_stup dfs
401: WHERE dfs.document_type = cp_document_type
402: AND l_start_at < upper_range
403: ORDER BY dfs.lower_range;
404: --

Line 1552: FROM igs_as_doc_fee_stup dfs

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
1552: FROM igs_as_doc_fee_stup dfs
1553: WHERE dfs.document_type = 'LIFE_TIME_TRANS';
1554: -- Variables
1555: l_item_number igs_as_doc_details.item_number%TYPE;
1556: l_doc_fee igs_as_order_hdr.order_fee%TYPE;

Line 1560: l_lifetime_fee igs_as_doc_fee_stup.amount%TYPE;

1556: l_doc_fee igs_as_order_hdr.order_fee%TYPE;
1557: l_delivery_fee igs_as_order_hdr.delivery_fee%TYPE;
1558: l_itm_row_id VARCHAR2 (25);
1559: l_fmnt_row_id VARCHAR2 (25);
1560: l_lifetime_fee igs_as_doc_fee_stup.amount%TYPE;
1561: l_default_country VARCHAR2 (80) := fnd_profile.VALUE ('OSS_COUNTRY_CODE');
1562: l_return_status VARCHAR2 (30);
1563: l_msg_data VARCHAR2 (1000);
1564: l_msg_count NUMBER;

Line 1774: l_lifetime_fee igs_as_doc_fee_stup.amount%TYPE;

1770: l_doc_fee igs_as_order_hdr.order_fee%TYPE;
1771: l_delivery_fee igs_as_order_hdr.delivery_fee%TYPE;
1772: l_itm_row_id VARCHAR2 (25);
1773: l_fmnt_row_id VARCHAR2 (25);
1774: l_lifetime_fee igs_as_doc_fee_stup.amount%TYPE;
1775: l_default_country VARCHAR2 (80) := fnd_profile.VALUE ('OSS_COUNTRY_CODE');
1776: l_return_status VARCHAR2 (30);
1777: l_msg_data VARCHAR2 (1000);
1778: l_msg_count NUMBER;