APPS.IBY_FD_EXTRACT_GEN_PVT dependencies on CE_BANK_ACCOUNTS

Line 748: FROM ce_bank_accounts ba

744: AND xml_pmt_lvl.payment_status IN('ISSUED', 'PAID')
745: AND(xml_pmt_lvl.positive_pay_file_created_flag = 'N' OR xml_pmt_lvl.positive_pay_file_created_flag IS NULL)
746: AND xml_pmt_lvl.internal_bank_account_id IN
747: (SELECT ba.bank_account_id
748: FROM ce_bank_accounts ba
749: WHERE ba.bank_account_name = p_internal_bank_account_name)
750: ;
751:
752: --cursor for - pmt instr id not supplied,negotiable payments, reselect - yes

Line 767: FROM ce_bank_accounts ba

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')
765: AND xml_pmt_lvl.internal_bank_account_id IN
766: (SELECT ba.bank_account_id
767: FROM ce_bank_accounts ba
768: WHERE ba.bank_account_name = p_internal_bank_account_name)
769: ;
770:
771: --cursor for - pmt instr id not supplied,voided payments, reselect - no

Line 787: FROM ce_bank_accounts ba

783: AND xml_pmt_lvl.payment_status IN('VOID','ISSUED','PAID')
784: AND(xml_pmt_lvl.positive_pay_file_created_flag = 'N' OR xml_pmt_lvl.positive_pay_file_created_flag IS NULL)
785: AND xml_pmt_lvl.internal_bank_account_id IN
786: (SELECT ba.bank_account_id
787: FROM ce_bank_accounts ba
788: WHERE ba.bank_account_name = p_internal_bank_account_name)
789: ;
790:
791: --cursor for - pmt instr id not supplied,voided payments, reselect - yes

Line 806: FROM ce_bank_accounts ba

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')
804: AND xml_pmt_lvl.internal_bank_account_id IN
805: (SELECT ba.bank_account_id
806: FROM ce_bank_accounts ba
807: WHERE ba.bank_account_name = p_internal_bank_account_name)
808: ;
809:
810: BEGIN

Line 1027: ce_bank_accounts ba

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
1031: AND pmt.internal_bank_account_id = ba.bank_account_id

Line 1053: ce_bank_accounts ba

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
1057: AND pmt.internal_bank_account_id = ba.bank_account_id

Line 1083: ce_bank_accounts ba

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
1087: AND pmt.internal_bank_account_id = ba.bank_account_id

Line 1109: ce_bank_accounts ba

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
1113: AND pmt.internal_bank_account_id = ba.bank_account_id