APPS.HZP_CUST_PKG dependencies on AR_DUNNING_LETTER_SETS

Line 446: v_dunning_type ar_dunning_letter_sets.dunning_type%type;

442: )
443: return varchar2 is
444: --
445: v_dunning_site hz_cust_site_uses.site_use_id%type;
446: v_dunning_type ar_dunning_letter_sets.dunning_type%type;
447: --
448: BEGIN
449: --
450: v_dunning_site := get_dunning_site(p_customer_id);

Line 457: ar_dunning_letter_sets dls

453: --
454: select dls.dunning_type
455: into v_dunning_type
456: from hz_customer_profiles prof,
457: ar_dunning_letter_sets dls
458: where prof.cust_account_id = p_customer_id
459: and prof.site_use_id is NULL
460: and prof.dunning_letter_set_id = dls.dunning_letter_set_id;
461:

Line 470: ar_dunning_letter_sets dls,

466: from hz_cust_site_uses su,
467: hz_cust_acct_sites ad_cus,
468: hz_customer_profiles cust_pro,
469: hz_customer_profiles site_pro,
470: ar_dunning_letter_sets dls,
471: hz_cust_accounts cus
472: where su.site_use_code = 'BILL_TO'
473: and su.status = 'A'
474: and su.site_use_id = p_bill_to_site_id