APPS.XTR_DNM_PKG dependencies on XTR_REVALUATION_DETAILS

Line 26: XTR_REVALUATION_DETAILS A,

22: , decode(sign(A.CURR_GAIN_LOSS_AMOUNT),-1,'LOSS','PROFIT') CURR_ACTION
23: , B.PERIOD_END
24: , 'REVAL' DATE_TYPE
25: FROM
26: XTR_REVALUATION_DETAILS A,
27: XTR_BATCHES B,
28: XTR_BATCH_EVENTS C,
29: XTR_PARTIES_V P,
30: GL_SETS_OF_BOOKS SOB

Line 46: FROM XTR_REVALUATION_DETAILS

42: order by A.DEAL_NO;
43:
44: Cursor cur_count IS
45: SELECT COUNT(*)
46: FROM XTR_REVALUATION_DETAILS
47: WHERE batch_id = p_batch_id
48: AND complete_flag = 'N';
49:
50: l_amount_type XTR_AMOUNT_TYPES.AMOUNT_TYPE%TYPE;