DBA Data[Home] [Help]

APPS.ZX_R11I_TAX_PARTNER_PKG dependencies on DUAL

Line 1282: individually for each item line updated. Hence, subsequent calls delete the

1278: zx_ptnr_neg_lines_tab.ADJUSTED_DOC_DATE.DELETE; --Bug14756523
1279:
1280: /* This initialization of zx_ptnr_neg_line_gt is incorrect.
1281: When multiple item lines are updated, "COPY_PTNR_TAX_LINE_BEF_UPD" is called
1282: individually for each item line updated. Hence, subsequent calls delete the
1283: earlier records inserted in zx_ptnr_neg_line_gt.
1284: As far as updating multiple item lines is concerned, records are deleted from
1285: zx_ptnr_neg_line_gt after each line update in zxvtxsrvcpkgb.pls */
1286:

Line 2036: FROM DUAL

2032: ZX_PTNR_NEG_LINES_TAB.BILL_FROM_GEOGRAPHY_TYPE4(i),
2033: ZX_PTNR_NEG_LINES_TAB.BILL_FROM_GEOGRAPHY_VALUE4(i),
2034: ZX_PTNR_NEG_LINES_TAB.RECEIVABLES_TRX_TYPE_ID(i),
2035: ZX_PTNR_NEG_LINES_TAB.ADJUSTED_DOC_DATE(i) --Bug14756523
2036: FROM DUAL
2037: WHERE NOT EXISTS (SELECT 'Y'
2038: FROM zx_ptnr_neg_line_gt
2039: WHERE application_id = ZX_PTNR_NEG_LINES_TAB.APPLICATION_ID(i)
2040: AND entity_code = ZX_PTNR_NEG_LINES_TAB.ENTITY_CODE(i)