DBA Data[Home] [Help]

APPS.OKL_LA_SALES_TAX_PVT dependencies on ZX_LINES

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

3377: -- This procedure logic will be executed in its entirety, only if SLA accounting
3378: -- option AMB is enabled.
3379: -- When enabled, it creates:
3380: -- 1. TRX header in OKL_TRX_CONTRACTS for type 'Upfront Tax'
3381: -- 2. TRX lines in OKL_TXL_CNTRCT_LNS for each line in ZX_LINES,
3382: -- store values for cle-id, tax_line_id, tax_amount, etc.
3383: -- 3. Identify tax treatment for each asset line, to derive stream type
3384: -- 4. Call a/c API for upfront tax records in OKL_TXL_CNTRCT_LNS
3385: -- Business Rules :

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 3462: , zx_lines txl

3458: , txl.tax_amt tax_amount
3459: FROM OKC_RULES_V rul
3460: , OKC_RULE_GROUPS_V rgp
3461: , okl_tax_sources txs
3462: , zx_lines txl
3463: WHERE rul.rgp_id = rgp.id
3464: AND rgp.dnz_chr_id = p_contract_id
3465: AND rgp.rgd_code = 'LAASTX'
3466: AND rul.rule_information_category = 'LAASTX'

Line 3498: , zx_lines txl

3494: , txl.tax_amt tax_amount
3495: FROM OKC_RULES_V rul
3496: , OKC_RULE_GROUPS_V rgp
3497: , okl_tax_sources txs
3498: , zx_lines txl
3499: WHERE rul.rgp_id = rgp.id
3500: AND rgp.dnz_chr_id = p_contract_id
3501: AND rgp.rgd_code = 'LAASTX'
3502: AND rul.rule_information_category = 'LAASTX'

Line 3531: , zx_lines txl

3527: , txs.id tax_header_id
3528: , txl.tax_line_id tax_line_id
3529: , txl.tax_amt tax_amount
3530: FROM okl_tax_sources txs
3531: , zx_lines txl
3532: WHERE txs.khr_id = p_contract_id
3533: AND txs.kle_id IS NULL
3534: AND txs.TAX_LINE_STATUS_CODE = 'ACTIVE'
3535: AND txs.TAX_CALL_TYPE_CODE = 'UPFRONT_TAX'

Line 3581: , zx_lines txl

3577: , txl.tax_amt tax_amount
3578: FROM OKC_RULES_V rul
3579: , OKC_RULE_GROUPS_V rgp
3580: , okl_tax_sources txs
3581: , zx_lines txl
3582: WHERE rul.rgp_id = rgp.id
3583: AND rgp.dnz_chr_id = p_contract_id
3584: AND rgp.rgd_code = 'LAASTX'
3585: AND rul.rule_information_category = 'LAASTX'

Line 3628: , zx_lines txl

3624: , txl.tax_amt tax_amount
3625: FROM OKC_RULES_V rul
3626: , OKC_RULE_GROUPS_V rgp
3627: , okl_tax_sources txs
3628: , zx_lines txl
3629: WHERE rul.rgp_id = rgp.id
3630: AND rgp.dnz_chr_id = p_contract_id
3631: AND rgp.rgd_code = 'LAASTX'
3632: AND rul.rule_information_category = 'LAASTX'

Line 3673: , zx_lines txl

3669: , txl.tax_amt tax_amount
3670: FROM OKC_RULES_V rul
3671: , OKC_RULE_GROUPS_V rgp
3672: , okl_tax_sources txs
3673: , zx_lines txl
3674: WHERE rul.rgp_id = rgp.id
3675: AND rgp.dnz_chr_id = p_contract_id
3676: AND rgp.rgd_code = 'LAASTX'
3677: AND rul.rule_information_category = 'LAASTX'

Line 3715: , zx_lines txl

3711: , txs.id tax_header_id
3712: , txl.tax_line_id tax_line_id
3713: , txl.tax_amt tax_amount
3714: FROM okl_tax_sources txs
3715: , zx_lines txl
3716: WHERE txs.khr_id = p_contract_id
3717: AND txs.kle_id IS NULL
3718: AND txs.TAX_LINE_STATUS_CODE = 'INACTIVE'
3719: AND txs.TAX_CALL_TYPE_CODE = 'UPFRONT_TAX'