APPS.XTR_CONFO_PROCESS_P dependencies on XTR_DEALS_V

Line 125: l_deal_no XTR_DEALS_V.DEAL_NO%TYPE;

121: P_PAYMENT_SCHEDULE IN VARCHAR2,
122: P_TOTAL OUT NOCOPY NUMBER,
123: P_SUCCESS OUT NOCOPY NUMBER) is
124: --
125: l_deal_no XTR_DEALS_V.DEAL_NO%TYPE;
126: l_deal_type XTR_DEALS_V.DEAL_TYPE%TYPE;
127: request_id NUMBER;
128: --
129: cursor GET_TERM_ACTION is

Line 126: l_deal_type XTR_DEALS_V.DEAL_TYPE%TYPE;

122: P_TOTAL OUT NOCOPY NUMBER,
123: P_SUCCESS OUT NOCOPY NUMBER) is
124: --
125: l_deal_no XTR_DEALS_V.DEAL_NO%TYPE;
126: l_deal_type XTR_DEALS_V.DEAL_TYPE%TYPE;
127: request_id NUMBER;
128: --
129: cursor GET_TERM_ACTION is
130: select a.DEAL_NO,

Line 133: XTR_DEALS_V b

129: cursor GET_TERM_ACTION is
130: select a.DEAL_NO,
131: b.DEAL_TYPE
132: from XTR_TERM_ACTIONS a,
133: XTR_DEALS_V b
134: where ((a.DEAL_NO = P_DEAL_NO and P_DEAL_NO is not null) or (P_DEAL_NO is null))
135: and a.DEAL_NO = b.DEAL_NO
136: and a.CREATED_ON = P_CREATED_ON
137: and ((P_TEMPLATE_TYPE = 'RETAIL TERM CPARTY PRIN ADJUST' and