DBA Data[Home] [Help]

APPS.IGS_FI_1098T_EXTRACT_DATA dependencies on IGS_PE_HZ_PTY_SITES

Line 2005: 'igs_pe_hz_pty_sites' in cursor 'cur_party_sites'

2001: Change History
2002: Who When What
2003: abshriva 30/11/05 Bug:4768071-Modification in where clause of cursor cur_party_sites
2004: abshriva 9/11/05 Bug:4695680-Modification in where clause and inclusion of new table
2005: 'igs_pe_hz_pty_sites' in cursor 'cur_party_sites'
2006: abshriva 26/10/05 Bug:4697644-Modification in where clause for cursor 'cur_party_sites'
2007:
2008: ***************************************************************** */
2009:

Line 2034: igs_pe_hz_pty_sites igsps

2030: ps.identifying_address_flag,
2031: ps.status
2032: FROM hz_party_site_uses hps,
2033: hz_party_sites ps,
2034: igs_pe_hz_pty_sites igsps
2035: WHERE ps.party_id = cp_n_person_id
2036: AND ps.party_site_id = hps.party_site_id
2037: AND hps.site_use_type = cp_v_party_site_use_code
2038: AND hps.status = 'A'