DBA Data[Home] [Help]

APPS.OKC_PRICE_PUB dependencies on OKC_RULE_GROUPS_B

Line 315: okc_rule_groups_b rgp

311: Return Varchar2 IS
312: cursor c1 Is
313: select rul.object1_id1
314: from okc_rules_b rul,
315: okc_rule_groups_b rgp
316: where rul.rgp_id = rgp.id
317: and rul.rule_information_category = p_category
318: and rul.jtot_object1_code = p_object_code
319: and rgp.cle_id = p_cle_id;

Line 340: okc_rule_groups_b rgp

336: cursor c1 Is
337: select rul.object1_id1,
338: rul.jtot_object1_code
339: from okc_rules_b rul,
340: okc_rule_groups_b rgp
341: where rul.rgp_id = rgp.id
342: and rul.rule_information_category = p_category
343: and rgp.cle_id = p_cle_id;
344: l_object_id okc_rules_b.object1_id1%TYPE;

Line 372: okc_rule_groups_b rgp

368: Return Varchar2 Is
369: cursor c1 Is
370: select rul.object1_id1
371: from okc_rules_b rul,
372: okc_rule_groups_b rgp
373: where rul.rgp_id = rgp.id
374: and rul.rule_information_category = p_category
375: and rul.jtot_object1_code = p_object_code
376: and rgp.chr_id = p_chr_id;

Line 398: okc_rule_groups_b rgp

394: cursor c1 Is
395: select rul.object1_id1,
396: rul.jtot_object1_code
397: from okc_rules_b rul,
398: okc_rule_groups_b rgp
399: where rul.rgp_id = rgp.id
400: and rul.rule_information_category = p_category
401: and rgp.chr_id = p_chr_id;
402: l_object_id okc_rules_b.object1_id1%TYPE;

Line 752: From OKC_RULE_GROUPS_B RG

748: RULE_INFORMATION1,
749: RULE_INFORMATION2,
750: RULE_INFORMATION3,
751: RULE_INFORMATION4
752: From OKC_RULE_GROUPS_B RG
753: ,OKC_RULES_B RL
754: Where RG.CLE_ID = p_contract_line_id
755: AND RG.ID = RL.RGP_ID
756: AND RULE_INFORMATION_CATEGORY = l_cat;