DBA Data[Home] [Help]

APPS.IGS_SV_BATCH_PROCESS_PKG dependencies on IGS_PE_HZ_PTY_SITES

Line 1047: igs_pe_hz_pty_sites igsps,

1043: IS
1044: SELECT 1
1045: FROM hz_locations loc,
1046: hz_party_sites ps,
1047: igs_pe_hz_pty_sites igsps,
1048: hz_party_site_uses usg
1049: WHERE
1050: ps.location_id = loc.location_id
1051: AND ps.party_site_id = igsps.party_site_id (+)

Line 2471: IGS_PE_HZ_PTY_SITES IGSPS,

2467: to_char(usg.party_site_id) activity_site_cd,
2468: null remarks
2469: FROM HZ_LOCATIONS loc,
2470: HZ_PARTY_SITES ps,
2471: IGS_PE_HZ_PTY_SITES IGSPS,
2472: hz_party_site_uses usg
2473: WHERE
2474: PS.LOCATION_ID = Loc.LOCATION_ID
2475: AND PS.PARTY_SITE_ID = IGSPS.PARTY_SITE_ID (+)

Line 2523: IGS_PE_HZ_PTY_SITES IGSPS,

2519: to_char(usg.party_site_id) activity_site_cd ,
2520: null remarks
2521: from HZ_LOCATIONS loc,
2522: HZ_PARTY_SITES ps,
2523: IGS_PE_HZ_PTY_SITES IGSPS,
2524: hz_party_site_uses usg
2525: where
2526: PS.LOCATION_ID = Loc.LOCATION_ID
2527: AND PS.PARTY_SITE_ID = IGSPS.PARTY_SITE_ID (+)