APPS.IBY_UPG_PPP_PKG dependencies on AP_CHECK_FORMATS

Line 799: ap_check_formats cf,

795: ppp.system_profile_code || '_' || to_char
796: (cf.check_format_id) || '_' || sfgdf.org_id))
797: system_profile_code
798: FROM
799: ap_check_formats cf,
800: ap_check_stocks_all cs,
801: ce_upg_bank_accounts cba,
802: ap_payment_programs pp,
803: jg_zz_pay_format_info gdf,

Line 932: FROM ap_check_formats cf, ap_payment_programs pp

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
933: WHERE cf.format_payments_program_id = pp.program_id)))
934: AND ppb.payment_format_code = ipf.format_code
935: AND ipf.format_type_code = 'OUTBOUND_PAYMENT_INSTRUCTION'
936: AND ppp.system_profile_code = app.system_profile_code

Line 2561: ap_check_formats cf,

2557: order by cs.check_stock_id) create_bepacct,
2558: rank() over (partition by cf.check_format_id, sfgdf.org_id, cs.bank_account_id
2559: order by cs.check_stock_id, key.bep_account_id) create_intba
2560: FROM
2561: ap_check_formats cf,
2562: ap_check_stocks_all cs,
2563: ce_upg_bank_accounts cba,
2564: ap_payment_programs pp,
2565: jg_zz_pay_format_info gdf,

Line 2775: FROM ap_check_formats cf,

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,
2776: ap_payment_programs pp
2777: WHERE cf.format_payments_program_id = pp.program_id))
2778: )
2779: AND ppp.payment_format_code = ipf.format_code

Line 2915: ap_check_formats cf,

2911: cf.last_update_login,
2912: rank() over (partition by app.system_profile_code
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,

Line 2968: FROM ap_check_formats cf,

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,
2969: ap_payment_programs pp
2970: WHERE cf.format_payments_program_id = pp.program_id))
2971: )
2972: AND ppb.payment_format_code = ipf.format_code