DBA Data[Home] [Help]

APPS.IGS_SV_NI_BATCH_PROCESS_PKG dependencies on IGS_PE_PARTYSITEUSE_V

Line 1870: igs_pe_partysiteuse_v usg

1866: province,
1867: country_cd,
1868: postal_code
1869: FROM igs_pe_addr_v adr,
1870: igs_pe_partysiteuse_v usg
1871: WHERE person_id = p_person_rec.person_id
1872: AND ( adr.status = 'A' AND SYSDATE BETWEEN NVL(start_dt,SYSDATE) AND NVL(end_dt, SYSDATE + 1) )
1873: AND usg.party_site_id = adr.party_site_id
1874: AND usg.site_use_type = g_f_addr_usage

Line 2045: igs_pe_partysiteuse_v usg

2041: country_cd,
2042: postal_code,
2043: adr.identifying_address_flag
2044: FROM igs_pe_addr_v adr,
2045: igs_pe_partysiteuse_v usg
2046: WHERE person_id = p_person_rec.person_id
2047: AND ( adr.status = 'A' AND SYSDATE BETWEEN NVL(start_dt,SYSDATE) AND NVL(end_dt, SYSDATE + 1) )
2048: AND usg.party_site_id = adr.party_site_id
2049: AND usg.site_use_type = g_us_addr_usage