DBA Data[Home] [Help]

APPS.ZX_ON_FLY_TRX_UPGRADE_AR_PKG dependencies on ZX_LINES_DET_FACTORS

Line 60: INTO ZX_LINES_DET_FACTORS(

56:
57:
58: INSERT ALL
59: WHEN trx_line_type IN ('LINE' ,'CB') THEN
60: INTO ZX_LINES_DET_FACTORS(
61: INTERNAL_ORGANIZATION_ID
62: ,APPLICATION_ID
63: ,ENTITY_CODE
64: ,EVENT_CLASS_CODE

Line 1763: (SELECT 1 FROM zx_lines_det_factors zxl

1759: AND rates.tax_status_code = status.tax_status_code(+)
1760: AND rates.content_owner_id = status.content_owner_id(+)
1761: AND NVL(arsysparam.tax_code, '!') <> 'Localization'
1762: AND NOT EXISTS
1763: (SELECT 1 FROM zx_lines_det_factors zxl
1764: WHERE zxl.APPLICATION_ID = 222
1765: AND zxl.EVENT_CLASS_CODE = DECODE(types.type,
1766: 'INV','INVOICE',
1767: 'CM', 'CREDIT_MEMO',

Line 1850: INTO ZX_LINES_DET_FACTORS(

1846:
1847:
1848: INSERT ALL
1849: WHEN trx_line_type IN ('LINE' ,'CB') THEN
1850: INTO ZX_LINES_DET_FACTORS(
1851: INTERNAL_ORGANIZATION_ID
1852: ,APPLICATION_ID
1853: ,ENTITY_CODE
1854: ,EVENT_CLASS_CODE