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.

[Home] [Help]

APPS.IBY_FD_EXTRACT_GEN_PVT dependencies on IBY_FORMATS_VL

Line 740: FROM iby_formats_vl ppfformat

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
740: FROM iby_formats_vl ppfformat
741: WHERE ppfformat.format_name = p_format_name)
742: AND xml_pmt_lvl.payment_date >= nvl(to_date(p_from_date, 'YYYY/MM/DD HH24:MI:SS'), xml_pmt_lvl.payment_date)
743: AND xml_pmt_lvl.payment_date <= nvl(to_date(p_to_date, 'YYYY/MM/DD HH24:MI:SS'), sysdate)
744: AND xml_pmt_lvl.payment_status IN('ISSUED', 'PAID')

Line 760: FROM iby_formats_vl ppfformat

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
760: FROM iby_formats_vl ppfformat
761: WHERE ppfformat.format_name = p_format_name)
762: AND xml_pmt_lvl.payment_date >= nvl(to_date(p_from_date, 'YYYY/MM/DD HH24:MI:SS'), xml_pmt_lvl.payment_date)
763: AND xml_pmt_lvl.payment_date <= nvl(to_date(p_to_date, 'YYYY/MM/DD HH24:MI:SS'), sysdate)
764: AND xml_pmt_lvl.payment_status IN('ISSUED', 'PAID')

Line 779: FROM iby_formats_vl ppfformat

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
779: FROM iby_formats_vl ppfformat
780: WHERE ppfformat.format_name = p_format_name)
781: AND decode(xml_pmt_lvl.payment_status,'VOID',xml_pmt_lvl.void_date,xml_pmt_lvl.payment_date) >= nvl(to_date(p_from_date, 'YYYY/MM/DD HH24:MI:SS'), decode(xml_pmt_lvl.payment_status,'VOID',xml_pmt_lvl.void_date,xml_pmt_lvl.payment_date))
782: 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)
783: AND xml_pmt_lvl.payment_status IN('VOID','ISSUED','PAID')

Line 799: FROM iby_formats_vl ppfformat

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
799: FROM iby_formats_vl ppfformat
800: WHERE ppfformat.format_name = p_format_name)
801: AND decode(xml_pmt_lvl.payment_status,'VOID',xml_pmt_lvl.void_date,xml_pmt_lvl.payment_date) >= nvl(to_date(p_from_date, 'YYYY/MM/DD HH24:MI:SS'), decode(xml_pmt_lvl.payment_status,'VOID',xml_pmt_lvl.void_date,xml_pmt_lvl.payment_date))
802: 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)
803: AND xml_pmt_lvl.payment_status IN('VOID','ISSUED','PAID')

Line 1026: iby_formats_vl ppfformat,

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
1030: AND ppp.positive_pay_format_code = ppfformat.format_code

Line 1052: iby_formats_vl ppfformat,

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
1056: AND ppp.positive_pay_format_code = ppfformat.format_code

Line 1082: iby_formats_vl ppfformat,

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
1086: AND ppp.positive_pay_format_code = ppfformat.format_code

Line 1108: iby_formats_vl ppfformat,

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
1112: AND ppp.positive_pay_format_code = ppfformat.format_code