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 344: iby_payment_profiles ppp,

340:
341: CURSOR l_ece_csr(p_payment_instruction_id IN NUMBER) IS
342: SELECT electronic_processing_channel
343: FROM
344: iby_payment_profiles ppp,
345: iby_pay_instructions_all ins
346: WHERE
347: ins.payment_instruction_id = p_payment_instruction_id
348: AND ins.payment_profile_id = ppp.payment_profile_id;

Line 735: FROM iby_xml_fd_pmt_1_0_v xml_pmt_lvl,iby_pay_instructions_all pmtinstr,iby_payment_profiles ppp

731:
732: --cursor for - pmt instr id not supplied,negotiable payments, reselect - no
733: CURSOR l_pospay_appp_csr_1_1 (p_from_date IN VARCHAR2,p_to_date IN VARCHAR2) IS
734: SELECT xmltype.getclobval(xmlelement("PositivePayDataExtract", xmlagg(xml_pmt_lvl.payment)))
735: FROM iby_xml_fd_pmt_1_0_v xml_pmt_lvl,iby_pay_instructions_all pmtinstr,iby_payment_profiles ppp
736: WHERE xml_pmt_lvl.payment_instruction_id = pmtinstr.payment_instruction_id
737: AND pmtinstr.payment_profile_id = ppp.payment_profile_id
738: AND ppp.positive_pay_format_code IN
739: (SELECT ppfformat.format_code

Line 755: FROM iby_xml_fd_pmt_1_0_v xml_pmt_lvl,iby_pay_instructions_all pmtinstr,iby_payment_profiles ppp

751:
752: --cursor for - pmt instr id not supplied,negotiable payments, reselect - yes
753: CURSOR l_pospay_appp_csr_1_2 (p_from_date IN VARCHAR2,p_to_date IN VARCHAR2) IS
754: SELECT xmltype.getclobval(xmlelement("PositivePayDataExtract", xmlagg(xml_pmt_lvl.payment)))
755: FROM iby_xml_fd_pmt_1_0_v xml_pmt_lvl,iby_pay_instructions_all pmtinstr,iby_payment_profiles ppp
756: WHERE xml_pmt_lvl.payment_instruction_id = pmtinstr.payment_instruction_id
757: AND pmtinstr.payment_profile_id = ppp.payment_profile_id
758: AND ppp.positive_pay_format_code IN
759: (SELECT ppfformat.format_code

Line 774: FROM iby_xml_fd_pmt_1_0_v xml_pmt_lvl,iby_pay_instructions_all pmtinstr,iby_payment_profiles ppp

770:
771: --cursor for - pmt instr id not supplied,voided payments, reselect - no
772: CURSOR l_pospay_appp_csr_2_1 (p_from_date IN VARCHAR2,p_to_date IN VARCHAR2) IS
773: SELECT xmltype.getclobval(xmlelement("PositivePayDataExtract", xmlagg(xml_pmt_lvl.payment)))
774: FROM iby_xml_fd_pmt_1_0_v xml_pmt_lvl,iby_pay_instructions_all pmtinstr,iby_payment_profiles ppp
775: WHERE xml_pmt_lvl.payment_instruction_id = pmtinstr.payment_instruction_id
776: AND pmtinstr.payment_profile_id = ppp.payment_profile_id
777: AND ppp.positive_pay_format_code IN
778: (SELECT ppfformat.format_code

Line 794: FROM iby_xml_fd_pmt_1_0_v xml_pmt_lvl,iby_pay_instructions_all pmtinstr,iby_payment_profiles ppp

790:
791: --cursor for - pmt instr id not supplied,voided payments, reselect - yes
792: CURSOR l_pospay_appp_csr_2_2 (p_from_date IN VARCHAR2,p_to_date IN VARCHAR2) IS
793: SELECT xmltype.getclobval(xmlelement("PositivePayDataExtract", xmlagg(xml_pmt_lvl.payment)))
794: FROM iby_xml_fd_pmt_1_0_v xml_pmt_lvl,iby_pay_instructions_all pmtinstr,iby_payment_profiles ppp
795: WHERE xml_pmt_lvl.payment_instruction_id = pmtinstr.payment_instruction_id
796: AND pmtinstr.payment_profile_id = ppp.payment_profile_id
797: AND ppp.positive_pay_format_code IN
798: (SELECT ppfformat.format_code

Line 1025: iby_payment_profiles ppp,

1021: SELECT pmt.payment_id,pmt.payment_instruction_id
1022: BULK COLLECT INTO l_paymentid_arr,l_paymentinstrid_arr
1023: FROM iby_xml_fd_pmt_1_0_v pmt,
1024: iby_pay_instructions_all pmtinstr,
1025: iby_payment_profiles ppp,
1026: iby_formats_vl ppfformat,
1027: ce_bank_accounts ba
1028: WHERE pmt.payment_instruction_id = pmtinstr.payment_instruction_id
1029: AND pmtinstr.payment_profile_id = ppp.payment_profile_id

Line 1051: iby_payment_profiles ppp,

1047: SELECT pmt.payment_id,pmt.payment_instruction_id
1048: BULK COLLECT INTO l_paymentid_arr,l_paymentinstrid_arr
1049: FROM iby_xml_fd_pmt_1_0_v pmt,
1050: iby_pay_instructions_all pmtinstr,
1051: iby_payment_profiles ppp,
1052: iby_formats_vl ppfformat,
1053: ce_bank_accounts ba
1054: WHERE pmt.payment_instruction_id = pmtinstr.payment_instruction_id
1055: AND pmtinstr.payment_profile_id = ppp.payment_profile_id

Line 1081: iby_payment_profiles ppp,

1077: SELECT pmt.payment_id,pmt.payment_instruction_id
1078: BULK COLLECT INTO l_paymentid_arr,l_paymentinstrid_arr
1079: FROM iby_xml_fd_pmt_1_0_v pmt,
1080: iby_pay_instructions_all pmtinstr,
1081: iby_payment_profiles ppp,
1082: iby_formats_vl ppfformat,
1083: ce_bank_accounts ba
1084: WHERE pmt.payment_instruction_id = pmtinstr.payment_instruction_id
1085: AND pmtinstr.payment_profile_id = ppp.payment_profile_id

Line 1107: iby_payment_profiles ppp,

1103: SELECT pmt.payment_id,pmt.payment_instruction_id
1104: BULK COLLECT INTO l_paymentid_arr,l_paymentinstrid_arr
1105: FROM iby_xml_fd_pmt_1_0_v pmt,
1106: iby_pay_instructions_all pmtinstr,
1107: iby_payment_profiles ppp,
1108: iby_formats_vl ppfformat,
1109: ce_bank_accounts ba
1110: WHERE pmt.payment_instruction_id = pmtinstr.payment_instruction_id
1111: AND pmtinstr.payment_profile_id = ppp.payment_profile_id

Line 3060: iby_payment_profiles pp, iby_remit_advice_setup sra_setup

3056:
3057: CURSOR l_sra_setup_csr (p_payment_id IN NUMBER) IS
3058: SELECT sra_setup.sra_override_payee_flag, sra_setup.remit_advice_delivery_method
3059: FROM iby_payments_all pmt, iby_pay_instructions_all ins,
3060: iby_payment_profiles pp, iby_remit_advice_setup sra_setup
3061: WHERE pmt.payment_id = p_payment_id
3062: AND pmt.payment_instruction_id = ins.payment_instruction_id
3063: AND pp.payment_profile_id = ins.payment_profile_id
3064: AND pp.system_profile_code = sra_setup.system_profile_code;