APPS.XTR_HEDGE_PROCESS_P dependencies on XTR_BATCHES

Line 930: and batch_id in (select batch_id from xtr_batches b where

926: and company_code = p_company
927: and not exists (select 'Y' from xtr_batch_events e
928: where e.batch_id = r.batch_id and
929: e.event_code = 'RETROET')
930: and batch_id in (select batch_id from xtr_batches b where
931: b.period_end <= p_cb_end_date)
932: and exists (select 'Y' from XTR_COMPANY_PARAMETERS
933: where company_code = p_company
934: and parameter_code = 'ACCNT_BTEST'

Line 961: and batch_id in (select batch_id from xtr_batches b where

957: and r.period_to > ha.maturity_date
958: and not exists (select 'Y' from xtr_batch_events e
959: where e.batch_id = r.batch_id and
960: e.event_code = 'RETROET')
961: and batch_id in (select batch_id from xtr_batches b where
962: b.period_end <= p_cb_end_date)
963: and exists (select 'Y' from XTR_COMPANY_PARAMETERS
964: where company_code = p_company
965: and parameter_code = 'ACCNT_BTEST'

Line 1101: select period_end from xtr_batches

1097: /*-------------------------------------------------------
1098: get end date for this batch
1099: --------------------------------------------------------*/
1100: cursor cur_date is
1101: select period_end from xtr_batches
1102: where batch_id = p_batch_id;
1103:
1104: /*-------------------------------------------------------
1105: get end date for immedietly previous batch

Line 1108: select max(period_end) from xtr_batches b, xtr_batch_events e

1104: /*-------------------------------------------------------
1105: get end date for immedietly previous batch
1106: --------------------------------------------------------*/
1107: cursor prv_date is
1108: select max(period_end) from xtr_batches b, xtr_batch_events e
1109: where b.batch_id = e.batch_id
1110: and b.batch_id < p_batch_id
1111: and e.event_code = 'RETROET'
1112: and b.company_code = p_company;