DBA Data[Home] [Help]

APPS.ZX_TAXWARE_USER_PKG dependencies on ZX_PTNR_LOCATION_INFO_GT

Line 2221: /* Bug 5007293: During negation: ZX_PTNR_LOCATION_INFO_GT is not yet populated */

2217: (l_view_name,
2218: trx_id_tab(i),
2219: trx_line_id_tab(i));
2220: IF arp_customer_code_tab(i) IS NULL THEN
2221: /* Bug 5007293: During negation: ZX_PTNR_LOCATION_INFO_GT is not yet populated */
2222:
2223: BEGIN
2224:
2225: SELECT account_number

Line 2256: FROM ZX_PTNR_LOCATION_INFO_GT zpli

2252: ELSE
2253: BEGIN
2254: SELECT zpli.bill_to_party_number
2255: INTO arp_customer_code_tab(i)
2256: FROM ZX_PTNR_LOCATION_INFO_GT zpli
2257: , ZX_EVNT_CLS_MAPPINGS zecm
2258: WHERE zpli.EVENT_CLASS_MAPPING_ID = zecm.EVENT_CLASS_MAPPING_ID
2259: AND zecm.EVENT_CLASS_CODE = event_class_code_tab(i)
2260: AND zecm.APPLICATION_ID = application_id_tab(i)

Line 2317: /* Bug 5007293: During negation: ZX_PTNR_LOCATION_INFO_GT is not yet populated */

2313: trx_line_id_tab(i));
2314:
2315: IF arp_customer_name_tab(i) IS NULL
2316: THEN
2317: /* Bug 5007293: During negation: ZX_PTNR_LOCATION_INFO_GT is not yet populated */
2318: IF g_line_negation THEN
2319: BEGIN
2320: SELECT pty.party_name
2321: INTO arp_customer_name_tab(i)

Line 2333: FROM ZX_PTNR_LOCATION_INFO_GT zpli

2329: ELSE
2330: BEGIN
2331: SELECT zpli.BILL_TO_PARTY_NAME
2332: INTO arp_customer_name_tab(i)
2333: FROM ZX_PTNR_LOCATION_INFO_GT zpli
2334: , ZX_EVNT_CLS_MAPPINGS zecm
2335: WHERE zpli.EVENT_CLASS_MAPPING_ID = zecm.EVENT_CLASS_MAPPING_ID
2336: AND zecm.EVENT_CLASS_CODE = event_class_code_tab(i)
2337: AND zecm.APPLICATION_ID = application_id_tab(i)