DBA Data[Home] [Help]

APPS.AR_RECEIPT_API_PUB dependencies on IBY_PMT_INSTR_USES_ALL

Line 4416: FROM iby_fndcpt_tx_extensions x, iby_pmt_instr_uses_all i

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

Line 4626: FROM iby_fndcpt_tx_extensions x, iby_pmt_instr_uses_all i

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: