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 9893: select XTR_REVALUATION_DETAILS_S.NEXTVAL

9889: for update of last_batch_id NOWAIT;
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

Line 10078: select XTR_REVALUATION_DETAILS_S.NEXTVAL

10074: And DEAL_TYPE = 'NI'
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