eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IBY_FD_EXTRACT_GEN_PVT dependencies on CE_BANK_ACCOUNTS

Line 972: FROM ce_bank_accounts ba

968: AND xml_pmt_lvl.payment_status IN('ISSUED', 'PAID')
969: AND(xml_pmt_lvl.positive_pay_file_created_flag = 'N' OR xml_pmt_lvl.positive_pay_file_created_flag IS NULL)
970: AND xml_pmt_lvl.internal_bank_account_id IN
971: (SELECT ba.bank_account_id
972: FROM ce_bank_accounts ba
973: WHERE ba.bank_account_name = p_internal_bank_account_name)
974: ;
975:
976: --cursor for - pmt instr id not supplied,negotiable payments, reselect - yes

Line 990: FROM ce_bank_accounts ba

986: AND xml_pmt_lvl.payment_date <= nvl(to_date(p_to_date, 'YYYY/MM/DD HH24:MI:SS'), sysdate)
987: AND xml_pmt_lvl.payment_status IN('ISSUED', 'PAID')
988: AND xml_pmt_lvl.internal_bank_account_id IN
989: (SELECT ba.bank_account_id
990: FROM ce_bank_accounts ba
991: WHERE ba.bank_account_name = p_internal_bank_account_name)
992: ;
993:
994: --cursor for - pmt instr id not supplied,voided payments, reselect - no

Line 1009: FROM ce_bank_accounts ba

1005: AND xml_pmt_lvl.payment_status IN('VOID')
1006: AND(xml_pmt_lvl.positive_pay_file_created_flag = 'N' OR xml_pmt_lvl.positive_pay_file_created_flag IS NULL)
1007: AND xml_pmt_lvl.internal_bank_account_id IN
1008: (SELECT ba.bank_account_id
1009: FROM ce_bank_accounts ba
1010: WHERE ba.bank_account_name = p_internal_bank_account_name)
1011: ;
1012:
1013: --cursor for - pmt instr id not supplied,voided payments, reselect - yes

Line 1027: FROM ce_bank_accounts ba

1023: AND decode(xml_pmt_lvl.payment_status,'VOID',xml_pmt_lvl.void_date,xml_pmt_lvl.payment_date) <= nvl(to_date(p_to_date, 'YYYY/MM/DD HH24:MI:SS'), sysdate)
1024: AND xml_pmt_lvl.payment_status IN('VOID')
1025: AND xml_pmt_lvl.internal_bank_account_id IN
1026: (SELECT ba.bank_account_id
1027: FROM ce_bank_accounts ba
1028: WHERE ba.bank_account_name = p_internal_bank_account_name)
1029: ;
1030:
1031: --cursor for - pmt instr id not supplied,negotiable and voided payments, reselect - no

Line 1046: FROM ce_bank_accounts ba

1042: AND xml_pmt_lvl.payment_status IN('VOID','ISSUED','PAID')
1043: AND(xml_pmt_lvl.positive_pay_file_created_flag = 'N' OR xml_pmt_lvl.positive_pay_file_created_flag IS NULL)
1044: AND xml_pmt_lvl.internal_bank_account_id IN
1045: (SELECT ba.bank_account_id
1046: FROM ce_bank_accounts ba
1047: WHERE ba.bank_account_name = p_internal_bank_account_name)
1048: ;
1049:
1050: --cursor for - pmt instr id not supplied,negotiable and voided payments, reselect - yes

Line 1064: FROM ce_bank_accounts ba

1060: AND decode(xml_pmt_lvl.payment_status,'VOID',xml_pmt_lvl.void_date,xml_pmt_lvl.payment_date) <= nvl(to_date(p_to_date, 'YYYY/MM/DD HH24:MI:SS'), sysdate)
1061: AND xml_pmt_lvl.payment_status IN('VOID','ISSUED','PAID')
1062: AND xml_pmt_lvl.internal_bank_account_id IN
1063: (SELECT ba.bank_account_id
1064: FROM ce_bank_accounts ba
1065: WHERE ba.bank_account_name = p_internal_bank_account_name)
1066: ;
1067:
1068: CURSOR l_pospay_appp_csr_11i (p_from_date IN VARCHAR2,p_to_date IN VARCHAR2) IS

Line 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)

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' )
1075: OR ( NVL(pmt.positive_pay_file_created_flag,'N') = 'N' AND NVL(UPPER(p_reselect),'NO') = 'NO' ) );

Line 1338: ce_bank_accounts ba

1334: BULK COLLECT INTO l_paymentid_arr,l_paymentinstrid_arr
1335: FROM iby_xml_fd_pmt_1_0_v pmt,
1336: iby_payment_profiles ppp,
1337: iby_formats_vl ppfformat,
1338: ce_bank_accounts ba
1339: WHERE pmt.payment_profile_id = ppp.payment_profile_id
1340: AND ppp.positive_pay_format_code = ppfformat.format_code
1341: AND pmt.internal_bank_account_id = ba.bank_account_id
1342: AND ppfformat.format_name = p_format_name

Line 1362: ce_bank_accounts ba

1358: BULK COLLECT INTO l_paymentid_arr,l_paymentinstrid_arr
1359: FROM iby_xml_fd_pmt_1_0_v pmt,
1360: iby_payment_profiles ppp,
1361: iby_formats_vl ppfformat,
1362: ce_bank_accounts ba
1363: WHERE pmt.payment_profile_id = ppp.payment_profile_id
1364: AND ppp.positive_pay_format_code = ppfformat.format_code
1365: AND pmt.internal_bank_account_id = ba.bank_account_id
1366: AND ppfformat.format_name = p_format_name

Line 1390: ce_bank_accounts ba

1386: BULK COLLECT INTO l_paymentid_arr,l_paymentinstrid_arr
1387: FROM iby_xml_fd_pmt_1_0_v pmt,
1388: iby_payment_profiles ppp,
1389: iby_formats_vl ppfformat,
1390: ce_bank_accounts ba
1391: WHERE pmt.payment_profile_id = ppp.payment_profile_id
1392: AND ppp.positive_pay_format_code = ppfformat.format_code
1393: AND pmt.internal_bank_account_id = ba.bank_account_id
1394: AND ppfformat.format_name = p_format_name

Line 1413: ce_bank_accounts ba

1409: BULK COLLECT INTO l_paymentid_arr,l_paymentinstrid_arr
1410: FROM iby_xml_fd_pmt_1_0_v pmt,
1411: iby_payment_profiles ppp,
1412: iby_formats_vl ppfformat,
1413: ce_bank_accounts ba
1414: WHERE pmt.payment_profile_id = ppp.payment_profile_id
1415: AND ppp.positive_pay_format_code = ppfformat.format_code
1416: AND pmt.internal_bank_account_id = ba.bank_account_id
1417: AND ppfformat.format_name = p_format_name

Line 1441: ce_bank_accounts ba

1437: BULK COLLECT INTO l_paymentid_arr,l_paymentinstrid_arr
1438: FROM iby_xml_fd_pmt_1_0_v pmt,
1439: iby_payment_profiles ppp,
1440: iby_formats_vl ppfformat,
1441: ce_bank_accounts ba
1442: WHERE pmt.payment_profile_id = ppp.payment_profile_id
1443: AND ppp.positive_pay_format_code = ppfformat.format_code
1444: AND pmt.internal_bank_account_id = ba.bank_account_id
1445: AND ppfformat.format_name = p_format_name

Line 1465: ce_bank_accounts ba

1461: BULK COLLECT INTO l_paymentid_arr,l_paymentinstrid_arr
1462: FROM iby_xml_fd_pmt_1_0_v pmt,
1463: iby_payment_profiles ppp,
1464: iby_formats_vl ppfformat,
1465: ce_bank_accounts ba
1466: WHERE pmt.payment_profile_id = ppp.payment_profile_id
1467: AND ppp.positive_pay_format_code = ppfformat.format_code
1468: AND pmt.internal_bank_account_id = ba.bank_account_id
1469: AND ppfformat.format_name = p_format_name

Line 1509: FROM ce_bank_accounts ba

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)
1511: AND pmt.payment_date >= NVL(to_date(l_from_date, 'YYYY/MM/DD HH24:MI:SS'), pmt.payment_date)
1512: AND pmt.payment_date <= NVL(to_date(l_to_date, 'YYYY/MM/DD HH24:MI:SS'), sysdate)
1513: AND ( ( NVL(UPPER(p_reselect),'NO') = 'YES' )