DBA Data[Home] [Help]

APPS.IGS_HE_EXTRACT_FIELDS_PKG dependencies on IGS_PE_PARTYSITEUSE_V

Line 1770: FROM igs_pe_partysiteuse_v a,

1766: -- smaddali modified this cursor to get records which are effective in the HESA submission period, bug#3235753
1767: -- jtmathew modified this cursor for bug 5210481 to remove igs_pe_addr_v view
1768: CURSOR c_addrus IS
1769: SELECT MAX( site_use_type)
1770: FROM igs_pe_partysiteuse_v a,
1771: hz_party_sites b,
1772: igs_pe_hz_pty_sites c,
1773: igs_he_code_values d
1774: WHERE a.party_site_id = b.party_site_id