DBA Data[Home] [Help]

APPS.IGS_PS_UNIT_LGCY_PKG dependencies on IGS_OR_STATUS

Line 1634: FROM igs_or_inst_org_base_v a, igs_or_status b

1630: l_d_ou_start_dt igs_ps_unit_ver_all.owner_ou_start_dt%TYPE;
1631: l_c_message_name VARCHAR2 (30);
1632: CURSOR c_org(cp_org_unit_cd igs_ps_tch_resp.org_unit_cd%TYPE) IS
1633: SELECT 'X'
1634: FROM igs_or_inst_org_base_v a, igs_or_status b
1635: WHERE a.party_number = cp_org_unit_cd
1636: AND a.org_status = b.org_status
1637: AND b.s_org_status <> 'INACTIVE';
1638: c_org_rec c_org%ROWTYPE;