APPS.IGS_AS_SS_DOC_REQUEST dependencies on IGS_LOOKUPS_VIEW

Line 262: igs_lookups_view lkup

258: item_status,
259: recip_inst_name,
260: recip_pers_name
261: FROM igs_as_doc_details dtls,
262: igs_lookups_view lkup
263: WHERE dtls.document_sub_type = lkup.lookup_code
264: AND lkup.lookup_type = 'IGS_AS_DOCUMENT_SUB_TYPE'
265: AND order_number = p_order_number
266: ORDER BY item_number; --msrinivi, for bug #2318474

Line 330: igs_lookups_view lkup

326: || recip_state
327: || ', '
328: || recip_country addr
329: FROM igs_as_doc_details dtls,
330: igs_lookups_view lkup
331: WHERE dtls.document_sub_type = lkup.lookup_code
332: AND lkup.lookup_type = 'IGS_AS_DOCUMENT_SUB_TYPE'
333: AND item_number = p_item_number
334: ORDER BY item_number; --msrinivi, for bug #2318474

Line 447: FROM igs_lookups_view

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'));
450: --
451: CURSOR c_num_free_cops IS

Line 455: FROM igs_lookups_view

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');
458: --
459: -- Local Variables

Line 1358: igs_lookups_view lk

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'
1362: AND NVL (pl.closed_ind, 'N') = 'N';

Line 1372: igs_lookups_view lk

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'
1376: AND NVL (pl.closed_ind, 'N') = 'N';

Line 2996: l_na_meaning igs_lookups_view.meaning%TYPE;

2992: AND view_application_id = 8405
2993: AND security_group_id = 0;
2994: c_prsn_info_rec c_prsn_info%ROWTYPE;
2995: l_one_item_created BOOLEAN := FALSE;
2996: l_na_meaning igs_lookups_view.meaning%TYPE;
2997: BEGIN
2998:
2999: IGS_GE_GEN_003.SET_ORG_ID(); -- swaghmar, bug# 4951054
3000: