DBA Data[Home] [Help]

APPS.OKS_EXTWARPRGM_OSO_PVT dependencies on OKC_K_HEADERS_V

Line 130: From OKC_K_HEADERS_V

126: l_jtf_id Varchar2(30);
127:
128: Cursor l_hdr_csr Is
129: Select Id Chr_Id
130: From OKC_K_HEADERS_V
131: Where Attribute1 = p_Object_Id
132: And End_date = p_EndDate ;
133:
134: Begin

Line 648: Authoring_Org_Id From OKC_K_HEADERS_V

644: )
645: Is
646: Cursor l_hdr_csr Is
647: Select Start_Date, End_Date ,
648: Authoring_Org_Id From OKC_K_HEADERS_V
649: Where id = p_chr_id;
650:
651: l_hdr_csr_rec l_hdr_csr%ROWTYPE;
652:

Line 697: , okc_k_headers_v hd

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
701: And rl.rule_information_category = 'EFY';

Line 877: Select contract_number From OKC_K_HEADERS_V

873:
874: FUNCTION GET_CONTRACT_NUMBER (p_hdrid IN Number) RETURN VARCHAR2
875: Is
876: Cursor l_hdr_Csr is
877: Select contract_number From OKC_K_HEADERS_V
878: Where id = p_hdrid;
879:
880: l_contract_number VARCHAR2(120);
881: