APPS.XTR_REVAL_PROCESS_P dependencies on DUAL

Line 43: from DUAL;

39: l_sysdate DATE :=trunc(sysdate);
40:
41: cursor BATCH is
42: select XTR_BATCHES_S.NEXTVAL
43: from DUAL;
44:
45: cursor BATCH_EXIST is
46: select 1
47: from XTR_BATCHES

Line 54: from DUAL;

50: l_exist number;
51:
52: cursor NUM is
53: select XTR_REVALUATION_DETAILS_S.NEXTVAL
54: from DUAL;
55:
56: -- Get Volatility (O, V) rows from Market Price table
57: cursor OPTION_VOLS is
58: select RIC_CODE, CURRENCY_A, CURRENCY_B, TERM_TYPE, TERM_LENGTH,

Line 9894: into l_reval_detail_id from DUAL;

9890:
9891:
9892: begin
9893: select XTR_REVALUATION_DETAILS_S.NEXTVAL
9894: into l_reval_detail_id from DUAL;
9895:
9896: -- we consider the deal is complete if all FV P/L and currency G/L has been derived
9897: if rec.fair_value is not null and currency_gl is not null
9898: and p_hedge_flag is NULL then

Line 10079: into l_reval_detail_id from DUAL;

10075: for update of FIRST_REVAL_BATCH_ID NOWAIT;
10076:
10077: begin
10078: select XTR_REVALUATION_DETAILS_S.NEXTVAL
10079: into l_reval_detail_id from DUAL;
10080:
10081: -- we consider the deal is complete if all FV P/L and currency G/L has been derived
10082: if rec.fair_value is not null and currency_gl is not null then
10083: l_complete := 'Y';

Line 10212: into l_event_id from DUAL;

10208: Close CHK_BATCH_RUN;
10209:
10210: -- insert new row to XTR_BATCH_EVENTS table
10211: select XTR_BATCH_EVENTS_S.NEXTVAL
10212: into l_event_id from DUAL;
10213:
10214: Insert into XTR_BATCH_EVENTS(batch_event_id, batch_id, event_code, authorized,
10215: authorized_by, authorized_on, created_by, creation_date,
10216: last_updated_by, last_update_date, last_update_login)