APPS.IBY_UPG_PPP_PKG dependencies on IBY_FORMATS_B

Line 894: iby_formats_b ipf,

890: format_code,
891: sfa.org_id
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 =

Line 923: FROM iby_formats_b ipf,

919:
920: UNION ALL
921:
922: SELECT distinct(ppb.system_profile_code) system_profile_code
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,

Line 2624: iby_formats_b ipf,

2620: LENGTH(sfa.jgzz_country_code)+2,
2621: LENGTH(sfa.jgzz_attribute_category)) format_code,
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

Line 2768: iby_formats_b ipf,

2764: 1 create_bepacct,
2765: rank() over (partition by ppp.system_profile_code
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

Line 2917: iby_formats_b ipf,

2913: order by app.payment_profile_id) create_header
2914: FROM
2915: ap_check_formats cf,
2916: ap_payment_programs pp,
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,

Line 2959: iby_formats_b ipf,

2955: ppp.last_update_login,
2956: rank() over (partition by app.system_profile_code
2957: order by app.payment_profile_id) create_header
2958: FROM
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,