APPS.XTR_HEDGE_PROCESS_P dependencies on XTR_REVALUATION_DETAILS

Line 401: from xtr_revaluation_details

397:
398: CURSOR reval (p_amount_type in varchar2, p_reval_id in number) is
399: --select decode(p_amount_type, 'UNREAL', unrealised_pl, curr_gain_loss_amount) reval_amt
400: select decode(p_amount_type, 'UNREAL', unrealised_pl, curr_gain_loss_amount) reval_amt
401: from xtr_revaluation_details
402: where revaluation_details_id = p_reval_id;
403:
404: cursor deal_mbtd (p_deal_no in number, p_date in DATE) is
405: select 'Y' from xtr_revaluation_details

Line 405: select 'Y' from xtr_revaluation_details

401: from xtr_revaluation_details
402: where revaluation_details_id = p_reval_id;
403:
404: cursor deal_mbtd (p_deal_no in number, p_date in DATE) is
405: select 'Y' from xtr_revaluation_details
406: where deal_no = p_deal_no
407: and realized_flag = 'Y'
408: and period_to < p_date;
409:

Line 411: select 'Y' from xtr_revaluation_details

407: and realized_flag = 'Y'
408: and period_to < p_date;
409:
410: cursor deal_motd (p_deal_no in number, p_date in DATE) is
411: select 'Y' from xtr_revaluation_details
412: where deal_no = p_deal_no
413: and realized_flag = 'Y'
414: and period_to = p_date;
415:

Line 439: select revaluation_details_id from xtr_revaluation_details

435: and amount_type = p_amount_type
436: and date_type = p_date_type;
437:
438: cursor reval_dtls(p_deal_no in number) is
439: select revaluation_details_id from xtr_revaluation_details
440: where deal_no = p_deal_no
441: and period_from >= nvl(l_mbst_date, period_from)
442: -- and period_to = l_temp_date -- Unit Test Change
443: and period_to <= l_temp_date

Line 452: from xtr_revaluation_details

448:
449:
450: cursor mbstdt(p_deal_no in number, p_end_date in DATE) is
451: select max(period_from)
452: from xtr_revaluation_details
453: where batch_id = p_batch_id
454: and deal_no = p_deal_no
455: and deal_type = 'FX'
456: and deal_subtype = 'FORWARD'

Line 767: from xtr_revaluation_details

763:
764:
765: cursor deal_ccy is
766: select distinct reval_ccy
767: from xtr_revaluation_details
768: where deal_no = p_deal_no;
769:
770: cursor sob_ccy is
771: select set_of_books_currency

Line 924: from xtr_revaluation_details r

920: ,unrealised_pl unrealised_pl
921: ,realised_pl realised_pl
922: ,curr_gain_loss_amount curr_gain_loss_amount
923: ,realized_flag realized_flag
924: from xtr_revaluation_details r
925: where batch_id is not null
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

Line 948: from xtr_revaluation_details r, xtr_eligible_hedges_v ha, xtr_hedge_relationships hr

944: ,0 unrealised_pl
945: ,0 realised_pl
946: ,0 curr_gain_loss_amount
947: ,NULL realized_flag
948: from xtr_revaluation_details r, xtr_eligible_hedges_v ha, xtr_hedge_relationships hr
949: where batch_id is not null
950: and r.company_code = p_company
951: and r.deal_no = hr.primary_code
952: and r.deal_type = 'FX'

Line 1076: from xtr_revaluation_details

1072: cursor get_reval is
1073: select unrealised_pl, realised_pl, curr_gain_loss_amount,
1074: (nvl(unrealised_pl,0)-nvl(curr_gain_loss_amount,0)) excluded_amt,
1075: revaluation_details_id
1076: from xtr_revaluation_details
1077: where deal_no = l_deal_no
1078: --and period_from = l_from_date
1079: --and period_to = l_to_date
1080: and period_from >= l_from_date

Line 1090: from xtr_revaluation_details

1086: get reval gain/loss amount for this deal
1087: --------------------------------------------------------*/
1088: cursor get_deal_gl(p_deal_no in NUMBER) is
1089: select DECODE(l_excl_item, 'NONE', unrealised_pl, 'TIME',curr_gain_loss_amount) deal_pl
1090: from xtr_revaluation_details
1091: where deal_no = p_deal_no
1092: and period_from = l_from_date
1093: and period_to = l_to_date
1094: and batch_id = p_batch_id;