APPS.OKC_CDRL_DT_PKG dependencies on EGO_FND_DSC_FLX_CTX_EXT

Line 63: FROM EGO_FND_DSC_FLX_CTX_EXT AG,

59: SELECT AG.DESCRIPTIVE_FLEX_CONTEXT_CODE ATTR_GROUP,
60: AG.ATTR_GROUP_ID ATTR_GROUP_ID,
61: AG.DESCRIPTIVE_FLEXFIELD_NAME DESC_FLEXFLD_NAME,
62: AG.MULTI_ROW MULTI_ROW
63: FROM EGO_FND_DSC_FLX_CTX_EXT AG,
64: okc_uda_deliverable_usages usg
65: WHERE usg.uda_template_id = p_uda_template_id
66: and usg.attr_group_id = ag.attr_group_id;
67:

Line 158: select attr_group_id from EGO_FND_DSC_FLX_CTX_EXT

154:
155: cursor c_del is
156: select extension_id , rownum num
157: from okc_deliverables_ext_b where attr_group_id in (
158: select attr_group_id from EGO_FND_DSC_FLX_CTX_EXT
159: where descriptive_flexfield_name = 'OKC_DELIVERABLES_EXT_ATTRS'
160: and descriptive_flex_context_code = 'CDRL_DIST_ADDR')
161: and deliverable_id = p_delId
162: and rownum < 39;