APPS.IBY_FD_EXTRACT_GEN_PVT dependencies on FV_TP_TS_AMT_DATA

Line 2019: FROM fv_tp_ts_amt_data fv, iby_pay_instructions_all iby

2015: XMLElement("Currency", XMLElement("Code", iby.payment_currency_code))
2016: )
2017: )
2018: )
2019: FROM fv_tp_ts_amt_data fv, iby_pay_instructions_all iby
2020: WHERE iby.payment_instruction_id = fv.payment_instruction_id
2021: AND iby.payment_instruction_id = p_payment_instruction_id;
2022:
2023: CURSOR l_fv_summary_csr (p_payment_instruction_id IN NUMBER,

Line 3221: FROM FV_TP_TS_AMT_DATA fv,

3217: l_treasury_symbol VARCHAR2(35);
3218:
3219: CURSOR l_ts_cur (p_payment_id NUMBER) IS
3220: SELECT fv.treasury_symbol
3221: FROM FV_TP_TS_AMT_DATA fv,
3222: iby_payments_all pmt
3223: WHERE pmt.payment_instruction_id = fv.payment_instruction_id
3224: AND pmt.payment_id = p_payment_id
3225: AND ROWNUM = 1;