APPS.OKC_SBCR_DT_PKG dependencies on EGO_FND_DSC_FLX_CTX_EXT

Line 66: FROM ego_fnd_dsc_flx_ctx_ext ag

62: CURSOR C_ATTR_GRP IS
63: SELECT ag.descriptive_flex_context_code attr_group,
64: ag.attr_group_id attr_group_id,
65: ag.descriptive_flexfield_name desc_flexfld_name
66: FROM ego_fnd_dsc_flx_ctx_ext ag
67: WHERE ag.attr_group_id IN (SELECT DISTINCT ext.attr_group_id FROM okc_rep_contracts_all_ext_b ext WHERE ext.contract_id = p_contract_id)
68: AND ag.multi_row = 'N';
69:
70: CURSOR C_ATTR(p_attr_group VARCHAR2, p_desc_flexfld_name VARCHAR2) IS

Line 158: FROM ego_fnd_dsc_flx_ctx_ext

154: AND fcu.descriptive_flex_context_code = 'SBCR_REC_AG'
155: AND fcu.end_user_column_name = 'RECOMMEND_PERCENT';
156:
157: SELECT attr_group_id INTO l_attr_group_id
158: FROM ego_fnd_dsc_flx_ctx_ext
159: WHERE descriptive_flexfield_name = 'OKC_REP_CONTRACT_HDR_EXT_ATTRS'
160: AND descriptive_flex_context_code = 'SBCR_REC_AG';
161:
162: l_sql := 'SELECT lkup.lookup_code, nvl2(ext.' || l_rec_type_col_name || ', ''Y'', ''N''), ext.' || l_rec_percent_col_name || ' FROM okc_rep_contracts_all_ext_b ext, fnd_lookups lkup' ||

Line 218: FROM ego_fnd_dsc_flx_ctx_ext

214: AND fcu.descriptive_flex_context_code = 'SBCR_PRE_ACQ'
215: AND fcu.end_user_column_name = 'ACQ_COMMENTS';
216:
217: SELECT attr_group_id INTO l_attr_group_id
218: FROM ego_fnd_dsc_flx_ctx_ext
219: WHERE descriptive_flexfield_name = 'OKC_REP_CONTRACT_HDR_EXT_ATTRS'
220: AND descriptive_flex_context_code = 'SBCR_PRE_ACQ';
221:
222: l_sql := 'SELECT ' || l_prev_acq_type_col_name || ', ' || l_prev_acq_cmt_col_name ||

Line 274: FROM ego_fnd_dsc_flx_ctx_ext

270: AND efdfce.descriptive_flex_context_code = fcu.descriptive_flex_context_code
271: AND efdfce.application_column_name = fcu.application_column_name;
272:
273: SELECT attr_group_id INTO l_attr_group_id
274: FROM ego_fnd_dsc_flx_ctx_ext
275: WHERE descriptive_flexfield_name = 'OKC_REP_CONTRACT_HDR_EXT_ATTRS'
276: AND descriptive_flex_context_code = 'SBCR_PROC_INFO_AG';
277:
278: l_sql := 'SELECT ' || l_sbcr_size_standard_col_name ||

Line 333: FROM ego_fnd_dsc_flx_ctx_ext

329: AND efdfce.descriptive_flex_context_code = fcu.descriptive_flex_context_code
330: AND efdfce.application_column_name = fcu.application_column_name;
331:
332: SELECT attr_group_id INTO l_attr_group_id
333: FROM ego_fnd_dsc_flx_ctx_ext
334: WHERE descriptive_flexfield_name = 'OKC_REP_CONTRACT_HDR_EXT_ATTRS'
335: AND descriptive_flex_context_code = 'SBCR_PROC_INFO_AG';
336:
337: l_sql := 'SELECT ' || l_sbcr_size_standard_col_name ||

Line 383: FROM ego_fnd_dsc_flx_ctx_ext

379: AND fcu.descriptive_flex_context_code = 'SBCR_REC_AG'
380: AND fcu.end_user_column_name = 'RECOMMENDATION_TYPE';
381:
382: SELECT attr_group_id INTO l_attr_group_id
383: FROM ego_fnd_dsc_flx_ctx_ext
384: WHERE descriptive_flexfield_name = 'OKC_REP_CONTRACT_HDR_EXT_ATTRS'
385: AND descriptive_flex_context_code = 'SBCR_REC_AG';
386:
387: l_sql := 'SELECT ''Y''' ||