APPS.IGS_PR_CP_GPA dependencies on IGS_PS_UNIT_REF_CD

Line 633: FROM igs_ps_unit_ref_cd urc, igs_ge_ref_cd_type rct

629: p_org_unit_cd;
630:
631: CURSOR c_org_included IS
632: SELECT 'X'
633: FROM igs_ps_unit_ref_cd urc, igs_ge_ref_cd_type rct
634: WHERE urc.unit_cd = p_unit_cd
635: AND urc.version_number = p_unit_version_number
636: AND urc.reference_cd_type = rct.reference_cd_type
637: AND rct.s_reference_cd_type = 'STATS'

Line 647: FROM igs_ps_unit_ref_cd urc, igs_ge_ref_cd_type rct

643: AND ostr1.include_or_exclude = 'INCLUDE');
644:
645: CURSOR c_org_excluded IS
646: SELECT 'X'
647: FROM igs_ps_unit_ref_cd urc, igs_ge_ref_cd_type rct
648: WHERE urc.unit_cd = p_unit_cd
649: AND urc.version_number = p_unit_version_number
650: AND urc.reference_cd_type = rct.reference_cd_type
651: AND rct.s_reference_cd_type = 'STATS'

Line 666: FROM igs_ps_unit_ref_cd urc, igs_ge_ref_cd_type rct

662: WHERE INSTR.stat_type = p_stat_type;
663:
664: CURSOR c_inst_included IS
665: SELECT 'X'
666: FROM igs_ps_unit_ref_cd urc, igs_ge_ref_cd_type rct
667: WHERE urc.unit_cd = p_unit_cd
668: AND urc.version_number = p_unit_version_number
669: AND urc.reference_cd_type = rct.reference_cd_type
670: AND rct.s_reference_cd_type = 'STATS'

Line 679: FROM igs_ps_unit_ref_cd urc, igs_ge_ref_cd_type rct

675: AND instr1.include_or_exclude = 'INCLUDE');
676:
677: CURSOR c_inst_excluded IS
678: SELECT 'X'
679: FROM igs_ps_unit_ref_cd urc, igs_ge_ref_cd_type rct
680: WHERE urc.unit_cd = p_unit_cd
681: AND urc.version_number = p_unit_version_number
682: AND urc.reference_cd_type = rct.reference_cd_type
683: AND rct.s_reference_cd_type = 'STATS'