DBA Data[Home] [Help]

APPS.ZX_ON_FLY_TRX_UPGRADE_AR_PKG dependencies on ZX_LINES_DET_FACTORS

Line 84: INTO ZX_LINES_DET_FACTORS(

80:
81:
82: INSERT ALL
83: WHEN trx_line_type IN ('LINE' ,'CB') THEN
84: INTO ZX_LINES_DET_FACTORS(
85: INTERNAL_ORGANIZATION_ID
86: ,APPLICATION_ID
87: ,ENTITY_CODE
88: ,EVENT_CLASS_CODE

Line 1843: (SELECT 1 FROM zx_lines_det_factors zxl

1839: AND rates.tax_status_code = status.tax_status_code(+)
1840: AND rates.content_owner_id = status.content_owner_id(+)
1841: AND NVL(arsysparam.tax_code, '!') <> 'Localization'
1842: AND NOT EXISTS
1843: (SELECT 1 FROM zx_lines_det_factors zxl
1844: WHERE zxl.APPLICATION_ID = 222
1845: AND zxl.EVENT_CLASS_CODE = DECODE(types.type,
1846: 'INV','INVOICE',
1847: 'CM', 'CREDIT_MEMO',

Line 1931: INTO ZX_LINES_DET_FACTORS(

1927:
1928:
1929: INSERT ALL
1930: WHEN trx_line_type IN ('LINE' ,'CB') THEN
1931: INTO ZX_LINES_DET_FACTORS(
1932: INTERNAL_ORGANIZATION_ID
1933: ,APPLICATION_ID
1934: ,ENTITY_CODE
1935: ,EVENT_CLASS_CODE