APPS.AR_RECEIPT_API_PUB dependencies on IBY_FNDCPT_TX_EXTENSIONS

Line 4407: from iby_fndcpt_tx_extensions

4403: AND hca.cust_account_id = l_customer_id ;
4404:
4405: SELECT INSTR_ASSIGNMENT_ID
4406: INTO l_assignment_id
4407: from iby_fndcpt_tx_extensions
4408: where trxn_extension_id = l_payment_trxn_extension_id;
4409: END IF;
4410:
4411:

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 4605: FROM iby_fndcpt_tx_extensions

4601: IF l_init_extension_id is NOT NULL THEN
4602:
4603: SELECT INSTR_ASSIGNMENT_ID
4604: into l_assignment_id
4605: FROM iby_fndcpt_tx_extensions
4606: where trxn_extension_id = l_init_extension_id;
4607:
4608:
4609: SELECT party.party_id

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: