APPS.OKC_REP_QA_CHECK_PVT dependencies on OKC_REP_CONTRACTS_ALL_EXT_B

Line 2010: ' FROM okc_rep_contracts_all_ext_b' ||

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 ||
2010: ' FROM okc_rep_contracts_all_ext_b' ||
2011: ' WHERE contract_id = ' || p_contract_id ||
2012: ' AND attr_group_id = ' || l_acq_hist_ag_id;
2013: BEGIN
2014: EXECUTE IMMEDIATE l_sql INTO l_acq_type;

Line 2024: FROM okc_rep_contracts_all_ext_b

2020:
2021: IF (l_acq_type = 'First Time Buy') THEN
2022:
2023: SELECT Count(*) INTO l_pre_acq_count
2024: FROM okc_rep_contracts_all_ext_b
2025: WHERE contract_id = p_contract_id
2026: AND attr_group_id = l_prev_acq_ag_id;
2027:
2028: IF (l_pre_acq_count > 0) THEN

Line 2087: FROM okc_rep_contracts_all_ext_b

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
2087: FROM okc_rep_contracts_all_ext_b
2088: WHERE contract_id = p_contract_id
2089: AND attr_group_id = l_rec_ag_id;
2090:
2091: IF(l_rec_count = 0) THEN

Line 2095: ' FROM okc_rep_contracts_all_ext_b' ||

2091: IF(l_rec_count = 0) THEN
2092:
2093:
2094: l_sql := 'SELECT ' || l_remarks_col_name ||
2095: ' FROM okc_rep_contracts_all_ext_b' ||
2096: ' WHERE contract_id = ' || p_contract_id ||
2097: ' AND attr_group_id = ' || l_add_info_ag_id;
2098: BEGIN
2099: EXECUTE IMMEDIATE l_sql INTO l_remarks;