DBA Data[Home] [Help]

APPS.IGS_EN_ELGBL_UNIT dependencies on IGS_PS_RPT_FMLY

Line 1652: igs_ps_rpt_fmly rep

1648: AND sua.version_number = psv.version_number
1649: AND ( ( sua.unit_cd = cp_unit_cd AND sua.version_number = cp_version_number)
1650: OR psv.rpt_fmly_id = ( SELECT psu.rpt_fmly_id
1651: FROM igs_ps_unit_ver psu,
1652: igs_ps_rpt_fmly rep
1653: WHERE psu.unit_cd = cp_unit_cd
1654: AND psu.version_number = cp_version_number
1655: AND psu.rpt_fmly_id = rep.rpt_fmly_id
1656: AND NVL(rep.closed_ind,'N') = 'N' )

Line 1677: igs_ps_rpt_fmly rep

1673: AND adv.version_number = psv.version_number
1674: AND ( ( adv.unit_cd = cp_unit_cd AND adv.version_number = cp_version_number )
1675: OR psv.rpt_fmly_id = (SELECT psu.rpt_fmly_id
1676: FROM igs_ps_unit_ver psu,
1677: igs_ps_rpt_fmly rep
1678: WHERE psu.unit_cd = cp_unit_cd
1679: AND psu.version_number = cp_version_number
1680: AND psu.rpt_fmly_id = rep.rpt_fmly_id
1681: AND NVL(rep.closed_ind,'N') = 'N')