APPS.IGI_DUNN_POST_UPG_PKG dependencies on AR_DUNNING_LETTER_SETS

Line 25: l_name ar_dunning_letter_sets.name%TYPE;

21: RETCODE OUT NOCOPY VARCHAR2) IS
22:
23: l_old_dls_id NUMBER;
24: l_dls_id NUMBER;
25: l_name ar_dunning_letter_sets.name%TYPE;
26: l_old_ccy_code igi_dun_letter_set_cur.currency_code%TYPE;
27: l_ccy_code igi_dun_letter_set_cur.currency_code%TYPE;
28: l_old_customer_profile_id NUMBER;
29: l_aging_bct_id ar_aging_buckets.aging_bucket_id%TYPE;

Line 348: ar_dunning_letter_sets adls,

344: SELECT distinct adls.dunning_letter_set_id,
345: adls.name,
346: idlsc.currency_code INTO l_dls_id, l_name, l_ccy_code
347: FROM igi_dun_letter_set_cur idlsc,
348: ar_dunning_letter_sets adls,
349: igi_dun_letter_sets idls
350: WHERE adls.dunning_letter_set_id = r_aging_bkt_lines_site.dunning_letter_set_id
351: AND idlsc.dunning_letter_set_id = r_aging_bkt_lines_site.dunning_letter_set_id
352: AND idls.dunning_letter_set_id = r_aging_bkt_lines_site.dunning_letter_set_id

Line 710: ar_dunning_letter_sets adls,

706: SELECT distinct adls.dunning_letter_set_id,
707: adls.name,
708: idlsc.currency_code INTO l_dls_id, l_name, l_ccy_code
709: FROM igi_dun_letter_set_cur idlsc,
710: ar_dunning_letter_sets adls,
711: igi_dun_letter_sets idls
712: WHERE adls.dunning_letter_set_id = r_aging_bkt_lines_site.dunning_letter_set_id
713: AND idlsc.dunning_letter_set_id = r_aging_bkt_lines_site.dunning_letter_set_id
714: AND idls.dunning_letter_set_id = r_aging_bkt_lines_site.dunning_letter_set_id