[Home] [Help]
828: ,jea.action_code action_code
829: ,jea.date_type date_type
830: from xtr_gain_loss_dnm dnm,
831: xtr_journal_entry_actions jea,
832: xtr_deals dea
833: where dnm.batch_id = in_batch_id
834: and jea.company_code = in_company
835: and jea.date_type = dnm.date_type
836: and jea.amount_type = dnm.amount_type
1020: jea.action_code action_code,
1021: jea.date_type date_type,
1022: dnm.reval_eff_flag reval_eff_flag
1023: from XTR_GAIN_LOSS_DNM dnm,
1024: XTR_DEALS dea,
1025: XTR_JOURNAL_ENTRY_ACTIONS jea
1026: Where dnm.batch_id = in_batch_id
1027: And jea.company_code = in_company
1028: And jea.company_code = dnm.company_code
1148: l_co_account_no in varchar2) RETURN BOOLEAN IS
1149:
1150: Cursor DEAL_VAL_BY is
1151: Select dual_authorisation_by
1152: from xtr_deals
1153: where deal_no = l_deal_no;
1154:
1155: Cursor GET_USER_DEAL_TYPE is
1156: Select user_deal_type
1159:
1160:
1161:
1162:
1163: l_deal_val_by XTR_DEALS.dual_authorisation_by%TYPE := NULL;
1164: l_ret_value boolean;
1165: l_user_deal_type XTR_DEAL_TYPES.user_deal_type%TYPE := NULL;
1166: l_trans_no_1 number := l_trans_no;
1167:
2338:
2339: select currency_buy , currency_sell
2340: into l_curr_buy, l_curr_sell
2341: from
2342: xtr_deals where deal_no = Q5_REC.deal_number;
2343:
2344:
2345: if l_curr_buy = l_sob_currency then
2346: l_curr := l_curr_sell;
2640:
2641: select currency_buy , currency_sell
2642: into l_curr_buy, l_curr_sell
2643: from
2644: xtr_deals where deal_no = Q6_REC.deal_number;
2645:
2646:
2647: if l_curr_buy = l_sob_currency then
2648: l_curr := l_curr_sell;