APPS.IGS_AS_SUARC_LGCY_PUB dependencies on IGS_GE_REF_CD

Line 207: FROM igs_ge_ref_cd refcd, igs_ge_ref_cd_type refcdt

203: l_number NUMBER;
204: CURSOR get_ref_code_id
205: IS
206: SELECT refcd.reference_code_id
207: FROM igs_ge_ref_cd refcd, igs_ge_ref_cd_type refcdt
208: WHERE refcd.reference_cd_type = refcdt.reference_cd_type
209: AND refcd.reference_cd = p_suarc_dtls_rec.reference_cd
210: AND refcd.reference_cd_type = p_suarc_dtls_rec.reference_cd_type;
211:

Line 326: FROM igs_ge_ref_cd refcd

322:
323: CURSOR cur_check_ref_cd
324: IS
325: SELECT 'X'
326: FROM igs_ge_ref_cd refcd
327: WHERE refcd.reference_cd = p_suarc_dtls_rec.reference_cd
328: AND refcd.reference_cd_type = p_suarc_dtls_rec.reference_cd_type;
329:
330: CURSOR cur_check_ref_cd_section_abv

Line 333: FROM igs_ge_ref_cd refcd, igs_ge_ref_cd_type refcdt

329:
330: CURSOR cur_check_ref_cd_section_abv
331: IS
332: SELECT 'X'
333: FROM igs_ge_ref_cd refcd, igs_ge_ref_cd_type refcdt
334: WHERE refcd.reference_cd_type = refcdt.reference_cd_type
335: AND refcd.reference_cd = p_suarc_dtls_rec.reference_cd
336: AND refcd.reference_cd_type = p_suarc_dtls_rec.reference_cd_type
337: AND refcdt.UNIT_FLAG='Y'

Line 344: FROM igs_ge_ref_cd refcd

340:
341: CURSOR get_ref_code_id
342: IS
343: SELECT refcd.reference_code_id
344: FROM igs_ge_ref_cd refcd
345: WHERE refcd.reference_cd = p_suarc_dtls_rec.reference_cd
346: AND refcd.reference_cd_type = p_suarc_dtls_rec.reference_cd_type;
347:
348: BEGIN