APPS.CSI_UTILITY_GRP dependencies on HZ_PARTIES

Line 906: -- AND party_source_table = 'HZ_PARTIES';

902: -- INTO l_party_found
903: -- FROM csi_t_party_details
904: -- WHERE txn_line_detail_id = dummy_rec.txn_line_detail_id
905: -- AND relationship_type_code = 'OWNER'
906: -- AND party_source_table = 'HZ_PARTIES';
907: l_party_found := 1;
908: IF l_party_found IS NOT NULL THEN
909: l_txn_oks_rec.transaction_type(j) := 'TRF';
910: j := j + 1;

Line 1848: FROM hz_parties hp, hz_party_sites hzp, hz_locations hz

1844: hz.address_style,
1845: hz.address_lines_phonetic,
1846: hz.county,
1847: hz.province
1848: FROM hz_parties hp, hz_party_sites hzp, hz_locations hz
1849: WHERE hp.party_id = hzp.party_id
1850: AND hzp.party_site_id = cp_location_id
1851: AND hzp.location_id = hz.location_id ;
1852: