APPS.OKL_AUTO_CASH_APPL_RULES_PVT dependencies on OKC_RULE_GROUPS_B

Line 201: FROM OKC_RULES_B a, OKC_RULE_GROUPS_B b

197: -- Cursor to fetch the Cash Application Rule for the given Contract Id
198:
199: CURSOR c_cash_rle_id_csr ( cp_khr_id IN NUMBER) IS
200: SELECT to_number(a.object1_id1)
201: FROM OKC_RULES_B a, OKC_RULE_GROUPS_B b
202: WHERE a.rgp_id = b.id
203: AND b.rgd_code = 'LABILL'
204: AND a.rule_information_category = 'LAINVD'
205: AND a.dnz_chr_id = b.chr_id

Line 1607: FROM OKC_RULES_B a, OKC_RULE_GROUPS_B b

1603: ORDER BY sequence_number;
1604:
1605: CURSOR c_cash_rle_id_csr ( cp_khr_id IN NUMBER) IS
1606: SELECT to_number(a.object1_id1)
1607: FROM OKC_RULES_B a, OKC_RULE_GROUPS_B b
1608: WHERE a.rgp_id = b.id
1609: AND b.rgd_code = 'LABILL'
1610: AND a.rule_information_category = 'LAINVD'
1611: AND a.dnz_chr_id = b.chr_id

Line 3022: FROM OKC_RULES_B a, OKC_RULE_GROUPS_B b

3018: */
3019:
3020: CURSOR c_cash_rle_id_csr ( cp_khr_id IN NUMBER) IS
3021: SELECT to_number(a.object1_id1)
3022: FROM OKC_RULES_B a, OKC_RULE_GROUPS_B b
3023: WHERE a.rgp_id = b.id
3024: AND b.rgd_code = 'LABILL'
3025: AND a.rule_information_category = 'LAINVD'
3026: AND a.dnz_chr_id = b.chr_id