APPS.IBY_FD_EXTRACT_GEN_PVT dependencies on FV_TP_TS_AMT_DATA

Line 2816: FROM fv_tp_ts_amt_data fv, iby_pay_instructions_all iby

2812: XMLElement("Currency", XMLElement("Code", iby.payment_currency_code))
2813: )
2814: )
2815: )
2816: FROM fv_tp_ts_amt_data fv, iby_pay_instructions_all iby
2817: WHERE iby.payment_instruction_id = fv.payment_instruction_id
2818: AND iby.payment_instruction_id = p_payment_instruction_id;
2819:
2820: CURSOR l_fv_summary_csr (p_payment_instruction_id IN NUMBER,

Line 4460: FROM FV_TP_TS_AMT_DATA fv,

4456: l_treasury_symbol VARCHAR2(35);
4457:
4458: CURSOR l_ts_cur (p_payment_id NUMBER) IS
4459: SELECT fv.treasury_symbol
4460: FROM FV_TP_TS_AMT_DATA fv,
4461: iby_payments_all pmt
4462: WHERE pmt.payment_instruction_id = fv.payment_instruction_id
4463: AND pmt.payment_id = p_payment_id
4464: AND ROWNUM = 1;