APPS.IGS_GE_VAL_PARAM dependencies on IGS_OR_UNIT

Line 937: CURSOR c_cv(cp_org_cd IGS_OR_UNIT.org_unit_cd%TYPE)

933: RETURN BOOLEAN
934: AS
935: --
936: -- Local Cursors
937: CURSOR c_cv(cp_org_cd IGS_OR_UNIT.org_unit_cd%TYPE)
938: IS
939: SELECT 'x'
940: FROM IGS_OR_UNIT ou,
941: IGS_OR_STATUS ous

Line 940: FROM IGS_OR_UNIT ou,

936: -- Local Cursors
937: CURSOR c_cv(cp_org_cd IGS_OR_UNIT.org_unit_cd%TYPE)
938: IS
939: SELECT 'x'
940: FROM IGS_OR_UNIT ou,
941: IGS_OR_STATUS ous
942: WHERE org_unit_cd LIKE cp_org_cd
943: AND ous.org_status = ou.org_status
944: AND ous.s_org_status = 'ACTIVE';

Line 954: IF IGS_GE_GEN_001.GENP_CHK_COL_UPPER('ORG_UNIT_CD','IGS_OR_UNIT')

950: IF p_org_cd IS NULL THEN
951: p_org_cd := '%';
952: END IF;
953: -- upper case test
954: IF IGS_GE_GEN_001.GENP_CHK_COL_UPPER('ORG_UNIT_CD','IGS_OR_UNIT')
955: THEN
956: p_org_cd := UPPER(p_org_cd);
957: END IF;
958: -- start of main loop