APPS.OKS_EXTWARPRGM_OSO_PVT dependencies on OKC_RULE_GROUPS_V

Line 236: SELECT ID INTO V_ID FROM OKC_RULE_GROUPS_V WHERE Dnz_CHR_ID = p_chr_id And cle_id Is Null;

232: Is
233: v_id NUMBER;
234: Begin
235: If (p_chr_id IS NOT NULL) Then
236: SELECT ID INTO V_ID FROM OKC_RULE_GROUPS_V WHERE Dnz_CHR_ID = p_chr_id And cle_id Is Null;
237: If V_ID IS NULL Then
238: return(NULL);
239: Else
240: return(V_ID);

Line 245: SELECT ID INTO V_ID FROM OKC_RULE_GROUPS_V WHERE CLE_ID = p_cle_id;

241: End If;
242: End If;
243:
244: If (p_cle_id IS NOT NULL) Then
245: SELECT ID INTO V_ID FROM OKC_RULE_GROUPS_V WHERE CLE_ID = p_cle_id;
246: If V_ID IS NULL Then
247: return(NULL);
248: Else
249: return(V_ID);

Line 448: From okc_rule_groups_v rg

444: )
445: Is
446: Cursor l_rulegroup_csr Is
447: Select Id
448: From okc_rule_groups_v rg
449: Where rg.cle_id = p_cle_id;
450:
451: --General
452: l_api_version CONSTANT NUMBER := 1.0;

Line 696: , okc_rule_groups_v rg

692: Is
693: Cursor l_timevalue_csr Is
694: Select rule_information1
695: From okc_rules_v rl
696: , okc_rule_groups_v rg
697: , okc_k_headers_v hd
698: Where hd.id = p_chr_id
699: And rg.chr_id = hd.id
700: And rl.rgp_id = rg.id

Line 705: From okc_rule_groups_v rg

701: And rl.rule_information_category = 'EFY';
702:
703: Cursor l_rulegroup_csr Is
704: Select Id
705: From okc_rule_groups_v rg
706: Where rg.dnz_chr_id = p_chr_id
707: And rg.cle_id Is Null;
708:
709: