APPS.IGI_DUNN_POST_UPG_PKG dependencies on IGI_DUN_LETTER_SET_CUR

Line 26: l_old_ccy_code igi_dun_letter_set_cur.currency_code%TYPE;

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;
30: l_not_exists BOOLEAN;

Line 27: l_ccy_code igi_dun_letter_set_cur.currency_code%TYPE;

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;
30: l_not_exists BOOLEAN;
31: l_length NUMBER;

Line 347: FROM igi_dun_letter_set_cur idlsc,

343:
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

Line 709: FROM igi_dun_letter_set_cur idlsc,

705:
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