APPS.OKL_BPD_ADVANCED_CASH_APP_PVT dependencies on OKC_RULES_B

Line 1046: FROM OKC_RULES_B a, OKC_RULE_GROUPS_B b

1042:
1043: -- get cash applic rule id
1044: CURSOR c_cash_rle_id_csr ( cp_khr_id IN NUMBER) IS
1045: SELECT to_number(a.object1_id1)
1046: FROM OKC_RULES_B a, OKC_RULE_GROUPS_B b
1047: WHERE a.rgp_id = b.id
1048: AND b.rgd_code = 'LABILL'
1049: AND a.rule_information_category = 'LAINVD'
1050: AND a.dnz_chr_id = b.chr_id

Line 1417: FROM OKC_RULES_B a, OKC_RULE_GROUPS_B b

1413:
1414: -- get cash applic rule id
1415: CURSOR c_cash_rle_id_csr ( cp_khr_id IN NUMBER) IS
1416: SELECT to_number(a.object1_id1)
1417: FROM OKC_RULES_B a, OKC_RULE_GROUPS_B b
1418: WHERE a.rgp_id = b.id
1419: AND b.rgd_code = 'LABILL'
1420: AND a.rule_information_category = 'LAINVD'
1421: AND a.dnz_chr_id = b.chr_id

Line 2069: FROM OKC_RULES_B a, OKC_RULE_GROUPS_B b

2065:
2066: -- get cash applic rule id
2067: CURSOR c_cash_rle_id_csr ( cp_khr_id IN NUMBER) IS
2068: SELECT to_number(a.object1_id1)
2069: FROM OKC_RULES_B a, OKC_RULE_GROUPS_B b
2070: WHERE a.rgp_id = b.id
2071: AND b.rgd_code = 'LABILL'
2072: AND a.rule_information_category = 'LAINVD'
2073: AND a.dnz_chr_id = b.chr_id

Line 2814: FROM OKC_RULES_B a, OKC_RULE_GROUPS_B b

2810:
2811: -- get cash applic rule id
2812: CURSOR c_cash_rle_id_csr ( cp_khr_id IN NUMBER) IS
2813: SELECT to_number(a.object1_id1)
2814: FROM OKC_RULES_B a, OKC_RULE_GROUPS_B b
2815: WHERE a.rgp_id = b.id
2816: AND b.rgd_code = 'LABILL'
2817: AND a.rule_information_category = 'LAINVD'
2818: AND a.dnz_chr_id = b.chr_id