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 IBY_PAYMENT_PROFILES

Line 525: iby_payment_profiles ppp,

521:
522: CURSOR l_ece_csr(p_payment_instruction_id IN NUMBER) IS
523: SELECT electronic_processing_channel
524: FROM
525: iby_payment_profiles ppp,
526: iby_pay_instructions_all ins
527: WHERE
528: ins.payment_instruction_id = p_payment_instruction_id
529: AND ins.payment_profile_id = ppp.payment_profile_id;

Line 960: FROM iby_xml_fd_pmt_1_0_v xml_pmt_lvl,iby_payment_profiles ppp

956:
957: --cursor for - pmt instr id not supplied,negotiable payments, reselect - no
958: CURSOR l_pospay_appp_csr_1_1 (p_from_date IN VARCHAR2,p_to_date IN VARCHAR2) IS
959: SELECT xmltype.getclobval(xmlagg(xml_pmt_lvl.payment))
960: FROM iby_xml_fd_pmt_1_0_v xml_pmt_lvl,iby_payment_profiles ppp
961: WHERE xml_pmt_lvl.payment_profile_id = ppp.payment_profile_id
962: AND ppp.positive_pay_format_code IN
963: (SELECT ppfformat.format_code
964: FROM iby_formats_vl ppfformat

Line 979: FROM iby_xml_fd_pmt_1_0_v xml_pmt_lvl,iby_payment_profiles ppp

975:
976: --cursor for - pmt instr id not supplied,negotiable payments, reselect - yes
977: CURSOR l_pospay_appp_csr_1_2 (p_from_date IN VARCHAR2,p_to_date IN VARCHAR2) IS
978: SELECT xmltype.getclobval(xmlagg(xml_pmt_lvl.payment))
979: FROM iby_xml_fd_pmt_1_0_v xml_pmt_lvl,iby_payment_profiles ppp
980: WHERE xml_pmt_lvl.payment_profile_id = ppp.payment_profile_id
981: AND ppp.positive_pay_format_code IN
982: (SELECT ppfformat.format_code
983: FROM iby_formats_vl ppfformat

Line 997: FROM iby_xml_fd_pmt_1_0_v xml_pmt_lvl,iby_payment_profiles ppp

993:
994: --cursor for - pmt instr id not supplied,voided payments, reselect - no
995: CURSOR l_pospay_appp_csr_2_1 (p_from_date IN VARCHAR2,p_to_date IN VARCHAR2) IS
996: SELECT xmltype.getclobval(xmlagg(xml_pmt_lvl.payment))
997: FROM iby_xml_fd_pmt_1_0_v xml_pmt_lvl,iby_payment_profiles ppp
998: WHERE xml_pmt_lvl.payment_profile_id = ppp.payment_profile_id
999: AND ppp.positive_pay_format_code IN
1000: (SELECT ppfformat.format_code
1001: FROM iby_formats_vl ppfformat

Line 1016: FROM iby_xml_fd_pmt_1_0_v xml_pmt_lvl,iby_payment_profiles ppp

1012:
1013: --cursor for - pmt instr id not supplied,voided payments, reselect - yes
1014: CURSOR l_pospay_appp_csr_2_2 (p_from_date IN VARCHAR2,p_to_date IN VARCHAR2) IS
1015: SELECT xmltype.getclobval(xmlagg(xml_pmt_lvl.payment))
1016: FROM iby_xml_fd_pmt_1_0_v xml_pmt_lvl,iby_payment_profiles ppp
1017: WHERE xml_pmt_lvl.payment_profile_id = ppp.payment_profile_id
1018: AND ppp.positive_pay_format_code IN
1019: (SELECT ppfformat.format_code
1020: FROM iby_formats_vl ppfformat

Line 1034: FROM iby_xml_fd_pmt_1_0_v xml_pmt_lvl,iby_payment_profiles ppp

1030:
1031: --cursor for - pmt instr id not supplied,negotiable and voided payments, reselect - no
1032: CURSOR l_pospay_appp_csr_3_1 (p_from_date IN VARCHAR2,p_to_date IN VARCHAR2) IS
1033: SELECT xmltype.getclobval(xmlagg(xml_pmt_lvl.payment))
1034: FROM iby_xml_fd_pmt_1_0_v xml_pmt_lvl,iby_payment_profiles ppp
1035: WHERE xml_pmt_lvl.payment_profile_id = ppp.payment_profile_id
1036: AND ppp.positive_pay_format_code IN
1037: (SELECT ppfformat.format_code
1038: FROM iby_formats_vl ppfformat

Line 1053: FROM iby_xml_fd_pmt_1_0_v xml_pmt_lvl,iby_payment_profiles ppp

1049:
1050: --cursor for - pmt instr id not supplied,negotiable and voided payments, reselect - yes
1051: CURSOR l_pospay_appp_csr_3_2 (p_from_date IN VARCHAR2,p_to_date IN VARCHAR2) IS
1052: SELECT xmltype.getclobval(xmlagg(xml_pmt_lvl.payment))
1053: FROM iby_xml_fd_pmt_1_0_v xml_pmt_lvl,iby_payment_profiles ppp
1054: WHERE xml_pmt_lvl.payment_profile_id = ppp.payment_profile_id
1055: AND ppp.positive_pay_format_code IN
1056: (SELECT ppfformat.format_code
1057: FROM iby_formats_vl ppfformat

Line 1336: iby_payment_profiles ppp,

1332:
1333: SELECT pmt.payment_id,pmt.payment_instruction_id
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

Line 1360: iby_payment_profiles ppp,

1356:
1357: SELECT pmt.payment_id,pmt.payment_instruction_id
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

Line 1388: iby_payment_profiles ppp,

1384:
1385: SELECT pmt.payment_id,pmt.payment_instruction_id
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

Line 1411: iby_payment_profiles ppp,

1407:
1408: SELECT pmt.payment_id,pmt.payment_instruction_id
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

Line 1439: iby_payment_profiles ppp,

1435:
1436: SELECT pmt.payment_id,pmt.payment_instruction_id
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

Line 1463: iby_payment_profiles ppp,

1459:
1460: SELECT pmt.payment_id,pmt.payment_instruction_id
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

Line 4269: iby_payment_profiles pp, iby_remit_advice_setup sra_setup

4265:
4266: CURSOR l_sra_setup_csr (p_payment_id IN NUMBER) IS
4267: SELECT sra_setup.sra_override_payee_flag, sra_setup.remit_advice_delivery_method
4268: FROM iby_payments_all pmt, iby_pay_instructions_all ins,
4269: iby_payment_profiles pp, iby_remit_advice_setup sra_setup
4270: WHERE pmt.payment_id = p_payment_id
4271: AND pmt.payment_instruction_id = ins.payment_instruction_id
4272: AND pp.payment_profile_id = ins.payment_profile_id
4273: AND pp.system_profile_code = sra_setup.system_profile_code;