APPS.XTR_HEDGE_PROCESS_P dependencies on XTR_SOURCE_TYPES

Line 2003: xtr_source_types st

1999:
2000: cursor source(hedge_no in NUMBER) is
2001: select st.source_type_id, instrument_item_flag
2002: from xtr_hedge_criteria hc,
2003: xtr_source_types st
2004: where hedge_attribute_id = hedge_no
2005: and hc.from_value = st.source_code
2006: and criteria_type = 'BASIC'
2007: and criteria_code = 'ITEM_SOURCE';

Line 2009: l_source_id XTR_SOURCE_TYPES.SOURCE_TYPE_ID%TYPE;

2005: and hc.from_value = st.source_code
2006: and criteria_type = 'BASIC'
2007: and criteria_code = 'ITEM_SOURCE';
2008:
2009: l_source_id XTR_SOURCE_TYPES.SOURCE_TYPE_ID%TYPE;
2010: l_iu_flag XTR_SOURCE_TYPES.INSTRUMENT_ITEM_FLAG%TYPE;
2011:
2012: idx NUMBER := 1;
2013: l_query VARCHAR2(32000);

Line 2010: l_iu_flag XTR_SOURCE_TYPES.INSTRUMENT_ITEM_FLAG%TYPE;

2006: and criteria_type = 'BASIC'
2007: and criteria_code = 'ITEM_SOURCE';
2008:
2009: l_source_id XTR_SOURCE_TYPES.SOURCE_TYPE_ID%TYPE;
2010: l_iu_flag XTR_SOURCE_TYPES.INSTRUMENT_ITEM_FLAG%TYPE;
2011:
2012: idx NUMBER := 1;
2013: l_query VARCHAR2(32000);
2014: l_select VARCHAR2(350);

Line 2440: xtr_source_types st

2436:
2437: cursor source(hedge_no in NUMBER) is
2438: select st.source_code
2439: from xtr_hedge_criteria hc,
2440: xtr_source_types st
2441: where hedge_attribute_id = hedge_no
2442: and hc.from_value = st.source_code
2443: and criteria_type = 'BASIC'
2444: and criteria_code = 'ITEM_SOURCE';

Line 2446: l_source_code XTR_SOURCE_TYPES.SOURCE_CODE%TYPE;

2442: and hc.from_value = st.source_code
2443: and criteria_type = 'BASIC'
2444: and criteria_code = 'ITEM_SOURCE';
2445:
2446: l_source_code XTR_SOURCE_TYPES.SOURCE_CODE%TYPE;
2447:
2448: BEGIN
2449: open source(P_HEDGE_NO);
2450: fetch source into l_source_code;