APPS.OKC_REP_QA_CHECK_PVT dependencies on EGO_FND_DSC_FLX_CTX_EXT

Line 2000: FROM ego_fnd_dsc_flx_ctx_ext

1996: AND fcu.descriptive_flex_context_code = 'SBCR_ACQ_HIST'
1997: AND fcu.end_user_column_name = 'SBCR_ACQ_TYPE';
1998:
1999: SELECT attr_group_id INTO l_acq_hist_ag_id
2000: FROM ego_fnd_dsc_flx_ctx_ext
2001: WHERE descriptive_flexfield_name = 'OKC_REP_CONTRACT_HDR_EXT_ATTRS'
2002: AND descriptive_flex_context_code = 'SBCR_ACQ_HIST';
2003:
2004: SELECT attr_group_id INTO l_prev_acq_ag_id

Line 2005: FROM ego_fnd_dsc_flx_ctx_ext

2001: WHERE descriptive_flexfield_name = 'OKC_REP_CONTRACT_HDR_EXT_ATTRS'
2002: AND descriptive_flex_context_code = 'SBCR_ACQ_HIST';
2003:
2004: SELECT attr_group_id INTO l_prev_acq_ag_id
2005: FROM ego_fnd_dsc_flx_ctx_ext
2006: WHERE descriptive_flexfield_name = 'OKC_REP_CONTRACT_HDR_EXT_ATTRS'
2007: AND descriptive_flex_context_code = 'SBCR_PRE_ACQ';
2008:
2009: l_sql := 'SELECT ' || l_acq_type_col_name ||

Line 2077: FROM ego_fnd_dsc_flx_ctx_ext

2073: AND fcu.descriptive_flex_context_code = 'SBCR_ADD_INFO'
2074: AND fcu.end_user_column_name = 'SBCR_REMARKS';
2075:
2076: SELECT attr_group_id INTO l_rec_ag_id
2077: FROM ego_fnd_dsc_flx_ctx_ext
2078: WHERE descriptive_flexfield_name = 'OKC_REP_CONTRACT_HDR_EXT_ATTRS'
2079: AND descriptive_flex_context_code = 'SBCR_REC_AG';
2080:
2081: SELECT attr_group_id INTO l_add_info_ag_id

Line 2082: FROM ego_fnd_dsc_flx_ctx_ext

2078: WHERE descriptive_flexfield_name = 'OKC_REP_CONTRACT_HDR_EXT_ATTRS'
2079: AND descriptive_flex_context_code = 'SBCR_REC_AG';
2080:
2081: SELECT attr_group_id INTO l_add_info_ag_id
2082: FROM ego_fnd_dsc_flx_ctx_ext
2083: WHERE descriptive_flexfield_name = 'OKC_REP_CONTRACT_HDR_EXT_ATTRS'
2084: AND descriptive_flex_context_code = 'SBCR_ADD_INFO';
2085:
2086: SELECT Count(*) INTO l_rec_count