[Home] [Help]
892: FROM jg_zz_sys_formats_all_b sfa)
893: sfgdf,
894: iby_formats_b ipf,
895: iby_upg_ppp_b ppp,
896: iby_bepinfo bep,
897: iby_bepkeys KEY
898: WHERE cf.format_payments_program_id =
899: pp.program_id
900: AND cf.check_format_id =
923: FROM iby_formats_b ipf,
924: iby_upg_ppp_tl ppp,
925: iby_upg_ppp_b ppb,
926: iby_acct_pmt_profiles_b app,
927: iby_bepinfo bep,
928: iby_bepkeys key1
929: WHERE(ipf.reference_format_code IS NULL OR(ipf.reference_format_code IS NOT NULL
930: AND ipf.reference_format_code NOT IN
931: (SELECT pp.program_name
2622: sfa.org_id
2623: FROM jg_zz_sys_formats_all_b sfa) sfgdf,
2624: iby_formats_b ipf,
2625: iby_upg_ppp_b ppp,
2626: iby_bepinfo bep,
2627: iby_bepkeys key
2628: WHERE cf.format_payments_program_id = pp.program_id
2629: AND cf.check_format_id = cs.check_format_id(+)
2630: AND cs.bank_account_id = cba.source_pk_id(+)
2766: order by key.bep_account_id) create_intba
2767: FROM
2768: iby_formats_b ipf,
2769: iby_upg_ppp_b ppp,
2770: iby_bepinfo bep,
2771: iby_bepkeys key
2772: WHERE (ipf.reference_format_code IS NULL OR
2773: (ipf.reference_format_code IS NOT NULL AND
2774: ipf.reference_format_code NOT IN (SELECT pp.program_name
2917: iby_formats_b ipf,
2918: iby_upg_ppp_tl ppp,
2919: iby_upg_ppp_b ppb,
2920: iby_acct_pmt_profiles_b app,
2921: iby_bepinfo bep,
2922: iby_bepkeys key,
2923: (SELECT SUBSTR(sfa.jgzz_attribute_category,
2924: LENGTH(sfa.jgzz_country_code)+2,
2925: LENGTH(sfa.jgzz_attribute_category)) format_code,
2959: iby_formats_b ipf,
2960: iby_upg_ppp_tl ppp,
2961: iby_upg_ppp_b ppb,
2962: iby_acct_pmt_profiles_b app,
2963: iby_bepinfo bep,
2964: iby_bepkeys key
2965: WHERE (ipf.reference_format_code IS NULL OR
2966: (ipf.reference_format_code IS NOT NULL AND
2967: ipf.reference_format_code NOT IN (SELECT pp.program_name