APPS.IGS_AS_SS_DOC_REQUEST dependencies on IGS_AS_DOC_DLVY_FEE

Line 410: FROM igs_as_doc_dlvy_fee dlfs

406: -- for the given document delivery method type.
407: --
408: CURSOR cur_delivery_fee_setup (cp_delivery_method_type IN VARCHAR2) IS
409: SELECT dlfs.amount amount
410: FROM igs_as_doc_dlvy_fee dlfs
411: WHERE dlfs.delivery_method_type = cp_delivery_method_type;
412: --
413: -- Cursor that checks if a person has paid life time fee or not
414: --

Line 464: l_delivery_fee igs_as_doc_dlvy_fee.amount%TYPE;

460: --
461: l_life_time_fee_paid VARCHAR2 (1);
462: rec_cur_doc_setup cur_doc_setup%ROWTYPE;
463: l_document_fee NUMBER (20, 2) DEFAULT 0;
464: l_delivery_fee igs_as_doc_dlvy_fee.amount%TYPE;
465: l_number_of_copies NUMBER;
466: l_copies_in_slab NUMBER;
467: l_num_stu_ords NUMBER := 0;
468: l_start_at NUMBER := 0;

Line 1320: l_delivery_fee igs_as_doc_dlvy_fee.amount%TYPE;

1316: lncopies_availded NUMBER;
1317: lnyearspassed NUMBER;
1318: lnmonthspassed NUMBER;
1319: lninperd NUMBER;
1320: l_delivery_fee igs_as_doc_dlvy_fee.amount%TYPE;
1321: l_free_plan_id igs_as_servic_plan.plan_id%TYPE;
1322: --
1323: -- Cursor to get all the plans subscribed by the student.
1324: -- Every time a user subscribes to a plan, a record is created in the doc_fee_pmnt table.

Line 1366: FROM igs_as_doc_dlvy_fee dlfs

1362: AND NVL (pl.closed_ind, 'N') = 'N';
1363: -- Cursor to get the delivery Fee:
1364: CURSOR cur_delivery_fee_setup (cp_delivery_method_type IN VARCHAR2) IS
1365: SELECT dlfs.amount amount
1366: FROM igs_as_doc_dlvy_fee dlfs
1367: WHERE dlfs.delivery_method_type = cp_delivery_method_type;
1368: --
1369: CURSOR cur_free_plan_id IS
1370: SELECT plan_id