DBA Data[Home] [Help]

APPS.OKC_RLD_PVT dependencies on FND_DESCR_FLEX_CONTEXTS

Line 563: from FND_DESCR_FLEX_CONTEXTS_VL

559: p_descriptive_flexfield_name IN VARCHAR2) IS
560: l_dff_var VARCHAR2(1) := '?';
561: Cursor l_dff_csr Is
562: select distinct '!'
563: from FND_DESCR_FLEX_CONTEXTS_VL
564: where descriptive_flexfield_name = p_descriptive_flexfield_name;
565: BEGIN
566: x_return_status := OKC_API.G_RET_STS_SUCCESS;
567: Open l_dff_csr;

Line 685: from FND_DESCR_FLEX_CONTEXTS_VL

681: p_descriptive_flexfield_name IN VARCHAR2) IS
682: l_var VARCHAR2(1) := '?';
683: Cursor l_csr Is
684: select distinct '!'
685: from FND_DESCR_FLEX_CONTEXTS_VL
686: where
687: APPLICATION_ID = p_application_id
688: and
689: DESCRIPTIVE_FLEX_CONTEXT_CODE = p_rule_code

Line 3327: FND_DESCR_FLEX_CONTEXTS A

3323: SELECT
3324: 'Y'
3325: FROM
3326: FND_DESCRIPTIVE_FLEXS B,
3327: FND_DESCR_FLEX_CONTEXTS A
3328: WHERE
3329: A.DESCRIPTIVE_FLEX_CONTEXT_CODE = rule_code
3330: and (A.APPLICATION_ID = B.APPLICATION_ID
3331: and B.APPLICATION_ID = appl_id)