DBA Data[Home] [Help]

APPS.ZX_JA_EXTRACT_PKG dependencies on HZ_CUST_ACCT_SITES_ALL

Line 1214: FROM hz_cust_acct_sites_all acct_site,

1210: global_attribute3
1211: BULK COLLECT INTO
1212: l_ind_classif_tbl,
1213: l_ind_sub_classif_tbl
1214: FROM hz_cust_acct_sites_all acct_site,
1215: zx_rep_trx_detail_t dtl
1216: WHERE acct_site.cust_acct_site_id = NVL(dtl.shipping_tp_address_id, dtl.billing_tp_address_id)
1217: AND dtl.application_id = 222
1218: AND dtl.request_id = p_trl_global_variables_rec.request_id ;