APPS.IBY_FD_EXTRACT_GEN_PVT dependencies on IBY_XML_FD_11IPMT_1_0_V

Line 1070: FROM IBY_XML_FD_11iPMT_1_0_V pmt

1066: ;
1067:
1068: CURSOR l_pospay_appp_csr_11i (p_from_date IN VARCHAR2,p_to_date IN VARCHAR2) IS
1069: SELECT xmltype.getclobval(xmlagg(pmt.payment))
1070: FROM IBY_XML_FD_11iPMT_1_0_V pmt
1071: WHERE pmt.internal_bank_account_id IN (SELECT ba.bank_account_id FROM ce_bank_accounts ba WHERE ba.bank_account_name = p_internal_bank_account_name)
1072: AND pmt.payment_date >= NVL(to_date(l_from_date, 'YYYY/MM/DD HH24:MI:SS'), pmt.payment_date)
1073: AND pmt.payment_date <= NVL(to_date(l_to_date, 'YYYY/MM/DD HH24:MI:SS'), sysdate)
1074: AND ( ( NVL(UPPER(p_reselect),'NO') = 'YES' )

Line 1506: FROM IBY_XML_FD_11iPMT_1_0_V pmt

1502: UPDATE ap_checks_all
1503: SET positive_pay_status_code = 'SENT AS VOIDED'
1504: WHERE check_ID IN
1505: (SELECT pmt.check_id
1506: FROM IBY_XML_FD_11iPMT_1_0_V pmt
1507: WHERE pmt.internal_bank_account_id IN
1508: (SELECT ba.bank_account_id
1509: FROM ce_bank_accounts ba
1510: WHERE ba.bank_account_name = p_internal_bank_account_name)