APPS.POR_TAX_PVT dependencies on HZ_PARTY_SITES

Line 244: FROM hz_party_sites hzps

240: p_tax_line_tbl(i).ship_from_party_site_id,
241: p_tax_line_tbl(i).bill_from_party_site_id,
242: p_tax_line_tbl(i).ship_to_location_id,
243: (SELECT hzps.location_id
244: FROM hz_party_sites hzps
245: WHERE hzps.party_site_id =p_tax_line_tbl(i).ship_from_party_site_id),
246: p_tax_line_tbl(i).bill_to_location_id,
247: p_tax_line_tbl(i).ship_third_pty_id,
248: p_tax_line_tbl(i).ship_third_pty_site_id,

Line 262: FROM hz_party_sites hzps

258: p_tax_line_tbl(i).input_tax_class,
259: p_tax_line_tbl(i).user_override_flag,
260: acc_ccid,
261: (SELECT hzps.location_id
262: FROM hz_party_sites hzps
263: WHERE hzps.party_site_id =p_tax_line_tbl(i).ship_from_party_site_id) /* 8680577 - Passing Location Id as Bill From Location Id */
264:
265: );
266:

Line 750: FROM hz_party_sites hzps

746: p_tax_line_tbl(i).ship_from_party_site_id,
747: p_tax_line_tbl(i).bill_from_party_site_id,
748: p_tax_line_tbl(i).ship_to_location_id,
749: (SELECT hzps.location_id
750: FROM hz_party_sites hzps
751: WHERE hzps.party_site_id =p_tax_line_tbl(i).ship_from_party_site_id),
752: p_tax_line_tbl(i).bill_to_location_id,
753: p_tax_line_tbl(i).ship_third_pty_id,
754: p_tax_line_tbl(i).ship_third_pty_site_id,

Line 768: FROM hz_party_sites hzps

764: NULL,
765: NULL,
766: p_tax_line_tbl(i).product_org_id,
767: (SELECT hzps.location_id
768: FROM hz_party_sites hzps
769: WHERE hzps.party_site_id =p_tax_line_tbl(i).ship_from_party_site_id)
770: );
771: i := i + 1;
772: EXIT WHEN (i > tbl_sz);

Line 1235: FROM hz_party_sites hzps

1231: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.SHIP_FROM_LOCATION_ID(i) := null;
1232: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.BILL_FROM_LOCATION_ID(i) := null;
1233: Else
1234: SELECT hzps.location_id INTO ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.SHIP_FROM_LOCATION_ID(i)
1235: FROM hz_party_sites hzps
1236: WHERE hzps.party_site_id =p_tax_info_tbl(i).ship_from_party_site_id and rownum =1 ;
1237: SELECT pvs.location_id INTO ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.BILL_FROM_LOCATION_ID(i)
1238: from hz_party_sites pvs /* - Passing Location Id as Bill From Location Id */
1239: WHERE pvs.party_site_id =p_tax_info_tbl(i).ship_from_party_site_id and rownum =1 ;

Line 1238: from hz_party_sites pvs /* - Passing Location Id as Bill From Location Id */

1234: SELECT hzps.location_id INTO ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.SHIP_FROM_LOCATION_ID(i)
1235: FROM hz_party_sites hzps
1236: WHERE hzps.party_site_id =p_tax_info_tbl(i).ship_from_party_site_id and rownum =1 ;
1237: SELECT pvs.location_id INTO ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.BILL_FROM_LOCATION_ID(i)
1238: from hz_party_sites pvs /* - Passing Location Id as Bill From Location Id */
1239: WHERE pvs.party_site_id =p_tax_info_tbl(i).ship_from_party_site_id and rownum =1 ;
1240:
1241:
1242: End if;