DBA Data[Home] [Help]

APPS.OKL_LA_SALES_TAX_PVT dependencies on ZX_LINES

Line 3177: -- 2. TRX lines in OKL_TXL_CNTRCT_LNS for each line in ZX_LINES,

3173: -- This procedure logic will be executed in its entirety, only if SLA accounting
3174: -- option AMB is enabled.
3175: -- When enabled, it creates:
3176: -- 1. TRX header in OKL_TRX_CONTRACTS for type 'Upfront Tax'
3177: -- 2. TRX lines in OKL_TXL_CNTRCT_LNS for each line in ZX_LINES,
3178: -- store values for cle-id, tax_line_id, tax_amount, etc.
3179: -- 3. Identify tax treatment for each asset line, to derive stream type
3180: -- 4. Call a/c API for upfront tax records in OKL_TXL_CNTRCT_LNS
3181: -- Business Rules :

Line 3220: , zx_lines txl

3216: , txl.tax_amt tax_amount
3217: FROM OKC_RULES_V rul
3218: , OKC_RULE_GROUPS_V rgp
3219: , okl_tax_sources txs
3220: , zx_lines txl
3221: WHERE rul.rgp_id = rgp.id
3222: AND rgp.dnz_chr_id = p_contract_id
3223: AND rgp.rgd_code = 'LAASTX'
3224: AND rul.rule_information_category = 'LAASTX'

Line 3258: , zx_lines txl

3254: , txl.tax_amt tax_amount
3255: FROM OKC_RULES_V rul
3256: , OKC_RULE_GROUPS_V rgp
3257: , okl_tax_sources txs
3258: , zx_lines txl
3259: WHERE rul.rgp_id = rgp.id
3260: AND rgp.dnz_chr_id = p_contract_id
3261: AND rgp.rgd_code = 'LAASTX'
3262: AND rul.rule_information_category = 'LAASTX'

Line 3294: , zx_lines txl

3290: , txl.tax_amt tax_amount
3291: FROM OKC_RULES_V rul
3292: , OKC_RULE_GROUPS_V rgp
3293: , okl_tax_sources txs
3294: , zx_lines txl
3295: WHERE rul.rgp_id = rgp.id
3296: AND rgp.dnz_chr_id = p_contract_id
3297: AND rgp.rgd_code = 'LAASTX'
3298: AND rul.rule_information_category = 'LAASTX'

Line 3327: , zx_lines txl

3323: , txs.id tax_header_id
3324: , txl.tax_line_id tax_line_id
3325: , txl.tax_amt tax_amount
3326: FROM okl_tax_sources txs
3327: , zx_lines txl
3328: WHERE txs.khr_id = p_contract_id
3329: AND txs.kle_id IS NULL
3330: AND txs.TAX_LINE_STATUS_CODE = 'ACTIVE'
3331: AND txs.TAX_CALL_TYPE_CODE = 'UPFRONT_TAX'

Line 3377: , zx_lines txl

3373: , txl.tax_amt tax_amount
3374: FROM OKC_RULES_V rul
3375: , OKC_RULE_GROUPS_V rgp
3376: , okl_tax_sources txs
3377: , zx_lines txl
3378: WHERE rul.rgp_id = rgp.id
3379: AND rgp.dnz_chr_id = p_contract_id
3380: AND rgp.rgd_code = 'LAASTX'
3381: AND rul.rule_information_category = 'LAASTX'

Line 3424: , zx_lines txl

3420: , txl.tax_amt tax_amount
3421: FROM OKC_RULES_V rul
3422: , OKC_RULE_GROUPS_V rgp
3423: , okl_tax_sources txs
3424: , zx_lines txl
3425: WHERE rul.rgp_id = rgp.id
3426: AND rgp.dnz_chr_id = p_contract_id
3427: AND rgp.rgd_code = 'LAASTX'
3428: AND rul.rule_information_category = 'LAASTX'

Line 3469: , zx_lines txl

3465: , txl.tax_amt tax_amount
3466: FROM OKC_RULES_V rul
3467: , OKC_RULE_GROUPS_V rgp
3468: , okl_tax_sources txs
3469: , zx_lines txl
3470: WHERE rul.rgp_id = rgp.id
3471: AND rgp.dnz_chr_id = p_contract_id
3472: AND rgp.rgd_code = 'LAASTX'
3473: AND rul.rule_information_category = 'LAASTX'

Line 3511: , zx_lines txl

3507: , txs.id tax_header_id
3508: , txl.tax_line_id tax_line_id
3509: , txl.tax_amt tax_amount
3510: FROM okl_tax_sources txs
3511: , zx_lines txl
3512: WHERE txs.khr_id = p_contract_id
3513: AND txs.kle_id IS NULL
3514: AND txs.TAX_LINE_STATUS_CODE = 'INACTIVE'
3515: AND txs.TAX_CALL_TYPE_CODE = 'UPFRONT_TAX'