APPS.IGS_PS_USEC_OCCURS_PKG dependencies on IGS_PS_USEC_OCUR_REF_V

Line 20: FROM igs_ps_usec_ocur_ref_v A,

16: vvutukur 05-Nov-2002 Enh#2613933.Modified the cursor cur_ref_cd to add join with igs_ps_usec_occurs_all.
17: ***************************************************************/
18: CURSOR cur_ref_cd IS
19: SELECT reference_code_type
20: FROM igs_ps_usec_ocur_ref_v A,
21: igs_ps_usec_occurs_all B
22: WHERE A.unit_section_occurrence_id = B.unit_section_occurrence_id
23: AND B.rowid = x_rowid;
24:

Line 25: l_ref_cd igs_ps_usec_ocur_ref_v.reference_code_type%TYPE;

21: igs_ps_usec_occurs_all B
22: WHERE A.unit_section_occurrence_id = B.unit_section_occurrence_id
23: AND B.rowid = x_rowid;
24:
25: l_ref_cd igs_ps_usec_ocur_ref_v.reference_code_type%TYPE;
26:
27: BEGIN
28:
29: OPEN cur_ref_cd;