APPS.XTR_REVAL_PROCESS_P dependencies on XTR_REVALUATION_DETAILS_S

Line 53: select XTR_REVALUATION_DETAILS_S.NEXTVAL

49:
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

Line 9874: select XTR_REVALUATION_DETAILS_S.NEXTVAL

9870: for update of last_batch_id NOWAIT;
9871:
9872:
9873: begin
9874: select XTR_REVALUATION_DETAILS_S.NEXTVAL
9875: into l_reval_detail_id from DUAL;
9876:
9877: -- we consider the deal is complete if all FV P/L and currency G/L has been derived
9878: if rec.fair_value is not null and currency_gl is not null

Line 10059: select XTR_REVALUATION_DETAILS_S.NEXTVAL

10055: And DEAL_TYPE = 'NI'
10056: for update of FIRST_REVAL_BATCH_ID NOWAIT;
10057:
10058: begin
10059: select XTR_REVALUATION_DETAILS_S.NEXTVAL
10060: into l_reval_detail_id from DUAL;
10061:
10062: -- we consider the deal is complete if all FV P/L and currency G/L has been derived
10063: if rec.fair_value is not null and currency_gl is not null then