APPS.IGS_AS_SS_DOC_REQUEST dependencies on IGS_AS_SERVIC_PLAN

Line 445: FROM igs_as_servic_plan

441: FROM igs_as_doc_details
442: WHERE person_id = p_person_id
443: AND item_number <> NVL (p_item_number, -1)
444: AND plan_id IN (SELECT plan_id
445: FROM igs_as_servic_plan
446: WHERE plan_type IN (SELECT meaning
447: FROM igs_lookups_view
448: WHERE lookup_type = 'TRANSCRIPT_SERVICE_PLAN_TYPE'
449: AND lookup_code = 'FREE_TRANSCRIPT'));

Line 453: FROM igs_as_servic_plan

449: AND lookup_code = 'FREE_TRANSCRIPT'));
450: --
451: CURSOR c_num_free_cops IS
452: SELECT NVL (quantity_limit, 0)
453: FROM igs_as_servic_plan
454: WHERE plan_type IN (SELECT meaning
455: FROM igs_lookups_view
456: WHERE lookup_type = 'TRANSCRIPT_SERVICE_PLAN_TYPE'
457: AND lookup_code = 'FREE_TRANSCRIPT');

Line 1321: l_free_plan_id igs_as_servic_plan.plan_id%TYPE;

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.
1325: --

Line 1342: igs_as_servic_plan pln

1338: pln.quantity_limit,
1339: pln.period_of_plan,
1340: pln.total_periods_covered
1341: FROM igs_as_doc_fee_pmnt subs,
1342: igs_as_servic_plan pln
1343: WHERE subs.plan_id = pln.plan_id
1344: AND subs.person_id = p_person_id
1345: AND subs.plan_id = cp_plan_id
1346: AND NVL (plan_discon_from, SYSDATE + 1) > SYSDATE;

Line 1357: FROM igs_as_servic_plan pl,

1353: unlimited_ind,
1354: quantity_limit,
1355: period_of_plan,
1356: total_periods_covered
1357: FROM igs_as_servic_plan pl,
1358: igs_lookups_view lk
1359: WHERE pl.plan_type = lk.meaning
1360: AND lk.lookup_type = 'TRANSCRIPT_SERVICE_PLAN_TYPE'
1361: AND lk.lookup_code = 'FREE_TRANSCRIPT'

Line 1371: FROM igs_as_servic_plan pl,

1367: WHERE dlfs.delivery_method_type = cp_delivery_method_type;
1368: --
1369: CURSOR cur_free_plan_id IS
1370: SELECT plan_id
1371: FROM igs_as_servic_plan pl,
1372: igs_lookups_view lk
1373: WHERE pl.plan_type = lk.meaning
1374: AND lk.lookup_type = 'TRANSCRIPT_SERVICE_PLAN_TYPE'
1375: AND lk.lookup_code = 'FREE_TRANSCRIPT'

Line 2196: FROM igs_as_servic_plan

2192: SELECT plan_id,
2193: plan_type,
2194: unlimited_ind,
2195: quantity_limit
2196: FROM igs_as_servic_plan
2197: WHERE plan_id = p_plan_id;
2198: plan_rec cur_plan%ROWTYPE;
2199: -- Cursor to update the doc_fee_pmnt
2200: CURSOR cur_doc_fee_pmnt IS