APPS.XTR_JOURNAL_PROCESS_P dependencies on XTR_DEALS

Line 831: xtr_deals dea

827: ,jea.action_code action_code
828: ,jea.date_type date_type
829: from xtr_gain_loss_dnm dnm,
830: xtr_journal_entry_actions jea,
831: xtr_deals dea
832: where dnm.batch_id = in_batch_id
833: and jea.company_code = in_company
834: and jea.date_type = dnm.date_type
835: and jea.amount_type = dnm.amount_type

Line 1023: XTR_DEALS dea,

1019: jea.action_code action_code,
1020: jea.date_type date_type,
1021: dnm.reval_eff_flag reval_eff_flag
1022: from XTR_GAIN_LOSS_DNM dnm,
1023: XTR_DEALS dea,
1024: XTR_JOURNAL_ENTRY_ACTIONS jea
1025: Where dnm.batch_id = in_batch_id
1026: And jea.company_code = in_company
1027: And jea.company_code = dnm.company_code

Line 1151: from xtr_deals

1147: l_co_account_no in varchar2) RETURN BOOLEAN IS
1148:
1149: Cursor DEAL_VAL_BY is
1150: Select dual_authorisation_by
1151: from xtr_deals
1152: where deal_no = l_deal_no;
1153:
1154: Cursor GET_USER_DEAL_TYPE is
1155: Select user_deal_type

Line 1162: l_deal_val_by XTR_DEALS.dual_authorisation_by%TYPE := NULL;

1158:
1159:
1160:
1161:
1162: l_deal_val_by XTR_DEALS.dual_authorisation_by%TYPE := NULL;
1163: l_ret_value boolean;
1164: l_user_deal_type XTR_DEAL_TYPES.user_deal_type%TYPE := NULL;
1165: l_trans_no_1 number := l_trans_no;
1166:

Line 2341: xtr_deals where deal_no = Q5_REC.deal_number;

2337:
2338: select currency_buy , currency_sell
2339: into l_curr_buy, l_curr_sell
2340: from
2341: xtr_deals where deal_no = Q5_REC.deal_number;
2342:
2343:
2344: if l_curr_buy = l_sob_currency then
2345: l_curr := l_curr_sell;

Line 2643: xtr_deals where deal_no = Q6_REC.deal_number;

2639:
2640: select currency_buy , currency_sell
2641: into l_curr_buy, l_curr_sell
2642: from
2643: xtr_deals where deal_no = Q6_REC.deal_number;
2644:
2645:
2646: if l_curr_buy = l_sob_currency then
2647: l_curr := l_curr_sell;