APPS.IGS_PS_VAL_CRV dependencies on IGS_OR_STATUS

Line 125: v_s_org_status IGS_OR_STATUS.s_org_status%TYPE;

121: p_org_unit_cd IN VARCHAR2 ,
122: p_start_dt IN DATE ,
123: p_message_name OUT NOCOPY VARCHAR2 )
124: RETURN BOOLEAN AS
125: v_s_org_status IGS_OR_STATUS.s_org_status%TYPE;
126: CURSOR c_get_s_org_status IS
127: SELECT s_org_status
128: FROM igs_or_inst_org_base_v,
129: IGS_OR_STATUS

Line 129: IGS_OR_STATUS

125: v_s_org_status IGS_OR_STATUS.s_org_status%TYPE;
126: CURSOR c_get_s_org_status IS
127: SELECT s_org_status
128: FROM igs_or_inst_org_base_v,
129: IGS_OR_STATUS
130: WHERE party_number = p_org_unit_cd AND
131: start_dt = p_start_dt AND
132: igs_or_inst_org_base_v.org_status = IGS_OR_STATUS.org_status;
133: BEGIN

Line 132: igs_or_inst_org_base_v.org_status = IGS_OR_STATUS.org_status;

128: FROM igs_or_inst_org_base_v,
129: IGS_OR_STATUS
130: WHERE party_number = p_org_unit_cd AND
131: start_dt = p_start_dt AND
132: igs_or_inst_org_base_v.org_status = IGS_OR_STATUS.org_status;
133: BEGIN
134: -- Validate organisational IGS_PS_UNIT system status.
135: p_message_name := NULL;
136: OPEN c_get_s_org_status;