APPS.IBY_UPG_PPP_PKG dependencies on IBY_BEPKEYS

Line 897: iby_bepkeys KEY

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 =
901: cs.check_format_id(+)

Line 928: iby_bepkeys key1

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
932: FROM ap_check_formats cf, ap_payment_programs pp

Line 2627: iby_bepkeys key

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(+)
2631: AND cba.source_application_id(+) = 200

Line 2771: iby_bepkeys key

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
2775: FROM ap_check_formats cf,

Line 2922: iby_bepkeys key,

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,
2926: sfa.org_id

Line 2964: iby_bepkeys key

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
2968: FROM ap_check_formats cf,