4412: /* Bug 11769052 : Get start and end date for instrument assignment. */
4413: BEGIN
4414: SELECT i.start_date, i.end_date
4415: INTO l_start_date, l_end_date
4416: FROM iby_fndcpt_tx_extensions x, iby_pmt_instr_uses_all i
4417: WHERE x.instr_assignment_id = i.instrument_payment_use_id
4418: AND x.trxn_extension_id = p_payment_trxn_extension_id
4419: AND x.INSTR_ASSIGNMENT_ID = l_assignment_id;
4420: If l_start_date is not null then
4622: /* Start - Bug 13056525 : Get start and end date for instrument assignment. */
4623: BEGIN
4624: SELECT i.start_date, i.end_date
4625: INTO l_start_date, l_end_date
4626: FROM iby_fndcpt_tx_extensions x, iby_pmt_instr_uses_all i
4627: WHERE x.instr_assignment_id = i.instrument_payment_use_id
4628: AND x.trxn_extension_id = p_payment_trxn_extension_id
4629: AND x.INSTR_ASSIGNMENT_ID = l_assignment_id;
4630: