APPS.OKL_LA_SALES_TAX_PVT dependencies on OKC_RULE_GROUPS_V

Line 438: OKC_RULE_GROUPS_V rgp

434: CURSOR get_contract_sales_tax_info(p_chr_id okc_k_headers_b.id%TYPE) IS
435: SELECT rul.rule_information1, rul.rule_information3, rul.rule_information4,
436: rul.rule_information5, rul.rule_information6, rul.rule_information7
437: FROM OKC_RULES_V rul,
438: OKC_RULE_GROUPS_V rgp
439: WHERE rul.rgp_id = rgp.id
440: AND rgp.dnz_chr_id = p_chr_id
441: AND rgp.cle_id is NULL
442: AND rgp.rgd_code = 'LAHDTX'

Line 448: OKC_RULE_GROUPS_V rgp

444:
445: CURSOR l_hdr_upfront_tax(p_chr_id okc_k_headers_b.id%TYPE) IS
446: SELECT rul.rule_information1
447: FROM OKC_RULES_V rul,
448: OKC_RULE_GROUPS_V rgp
449: WHERE rul.rgp_id = rgp.id
450: AND rgp.dnz_chr_id = p_chr_id
451: AND rgp.cle_id is NULL
452: AND rgp.rgd_code = 'LAHDTX'

Line 712: OKC_RULE_GROUPS_V rgp

708: CURSOR get_contract_sales_tax_info(p_chr_id okc_k_headers_b.id%TYPE) IS
709: SELECT rul.rule_information1, rul.rule_information3, rul.rule_information4,
710: rul.rule_information5, rul.rule_information6, rul.rule_information7
711: FROM OKC_RULES_V rul,
712: OKC_RULE_GROUPS_V rgp
713: WHERE rul.rgp_id = rgp.id
714: AND rgp.dnz_chr_id = p_chr_id
715: AND rgp.cle_id is NULL
716: AND rgp.rgd_code = 'LAHDTX'

Line 739: OKC_RULE_GROUPS_V rgp,

735: CURSOR get_asset_sales_tax_info(p_chr_id okc_k_headers_b.id%TYPE,
736: p_cle_id okc_k_lines_v.id%TYPE) IS
737: SELECT rul.id, rul.rule_information5, cle.ORIG_SYSTEM_ID1
738: FROM OKC_RULES_V rul,
739: OKC_RULE_GROUPS_V rgp,
740: okc_k_lines_b cle
741: WHERE rul.rgp_id = rgp.id
742: AND rgp.dnz_chr_id = p_chr_id
743: AND rgp.cle_id = p_cle_id

Line 753: OKC_RULE_GROUPS_V rgp

749: CURSOR get_sales_tax_prc_info(p_chr_id okc_k_headers_b.id%TYPE) IS
750: SELECT rul.rule_information1, rul.rule_information2,
751: rul.rule_information3, rul.rule_information4, rul.rule_information4
752: FROM OKC_RULES_V rul,
753: OKC_RULE_GROUPS_V rgp
754: WHERE rul.rgp_id = rgp.id
755: AND rgp.dnz_chr_id = p_chr_id
756: AND rgp.cle_id is NULL
757: AND rgp.rgd_code = 'LAHDTX'

Line 3422: , OKC_RULE_GROUPS_V rgp

3418: , txs.id tax_header_id
3419: , txl.tax_line_id tax_line_id
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

Line 3460: , OKC_RULE_GROUPS_V rgp

3456: , txs.id tax_header_id
3457: , txl.tax_line_id tax_line_id
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

Line 3496: , OKC_RULE_GROUPS_V rgp

3492: , txs.id tax_header_id
3493: , txl.tax_line_id tax_line_id
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

Line 3579: , OKC_RULE_GROUPS_V rgp

3575: , txs.id tax_header_id
3576: , txl.tax_line_id tax_line_id
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

Line 3626: , OKC_RULE_GROUPS_V rgp

3622: , txs.id tax_header_id
3623: , txl.tax_line_id tax_line_id
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

Line 3671: , OKC_RULE_GROUPS_V rgp

3667: , txs.id tax_header_id
3668: , txl.tax_line_id tax_line_id
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