APPS.OKL_FUNDING_PVT dependencies on OKC_RULE_GROUPS_B

Line 505: l_rgpv_id okc_rule_groups_b.id%type;

501: l_grp_row_not_found boolean;
502: l_expired_row_found boolean;
503:
504: l_dummy number;
505: l_rgpv_id okc_rule_groups_b.id%type;
506: l_todo_item_code okl_crd_fund_checklists_tpl_uv.TODO_ITEM_CODE%type;
507: l_mandatory_flag okl_crd_fund_checklists_tpl_uv.mandatory_flag%type;
508: l_note okl_crd_fund_checklists_tpl_uv.note%type;
509: l_status okl_crd_fund_checklists_tpl_uv.status%type;

Line 543: from okc_rule_groups_b rgp

539: -- Funded contract group
540: ---------------------------------------------------------------------------------------------------
541: cursor c_grp (p_chr_id number) is
542: select rgp.id
543: from okc_rule_groups_b rgp
544: where rgp.dnz_chr_id = p_chr_id
545: and rgp.RGD_CODE = G_FUNDING_CHKLST_TPL
546: ;
547:

Line 1343: from okc_rule_groups_b rgp

1339: select object1_id1 cust_acct_site_id
1340: from okc_rules_b rul
1341: where rul.rule_information_category = 'BTO'
1342: and exists (select '1'
1343: from okc_rule_groups_b rgp
1344: where rgp.id = rul.rgp_id
1345: and rgp.rgd_code = 'LABILL'
1346: and rgp.chr_id = rul.dnz_chr_id
1347: and rgp.chr_id = p_chr_id );

Line 2892: okc_rules_b rul, okc_rule_groups_b rgp

2888: IS
2889:
2890:
2891: SELECT nvl(rul.rule_information1, 'N') FROM
2892: okc_rules_b rul, okc_rule_groups_b rgp
2893: WHERE rul.rule_information_category='LARLES'
2894: AND rgp.id = rul.rgp_id
2895: AND rgp.rgd_code = 'LARLES'
2896: AND rgp.dnz_chr_id= p_contract_id;