APPS.IGS_AS_GEN_004 dependencies on IGS_PS_UNIT_STAT

Line 740: igs_ps_unit_stat us

736: igs_as_unit_class ucl,
737: igs_ca_inst ci,
738: igs_ps_unit_ver uv,
739: igs_ca_stat cs,
740: igs_ps_unit_stat us
741: WHERE uop.unit_cd LIKE p_unit_cd
742: AND uop.unit_cd = uv.unit_cd
743: AND uop.version_number = uv.version_number
744: AND uv.unit_status = us.unit_status

Line 1290: -- SUA IGS_PS_UNIT status is invalid

1286: AND v_message_name <> 'IGS_AS_SUA_STATUS_INVALID_COM'
1287: ) THEN
1288: -- Do not perform insert
1289: IF v_message_name = 'IGS_AS_SUA_STATUS_INVALID' THEN
1290: -- SUA IGS_PS_UNIT status is invalid
1291: p_message_name := 'IGS_AS_SPLAPPL_NC_ASSITEM_SUA';
1292: RETURN FALSE;
1293: ELSE
1294: -- SUA ass item is invalid