APPS.IEX_DUNNING_PUB dependencies on FND_LANGUAGES

Line 2523: CURSOR c_fnd_languages IS

2519: last_update_login
2520: from ar_dunning_letter_sets
2521: where dunning_type = 'STAGED_DUNNING';
2522:
2523: CURSOR c_fnd_languages IS
2524: SELECT language_code
2525: FROM fnd_languages
2526: WHERE installed_flag IN ('B','I');
2527:

Line 2525: FROM fnd_languages

2521: where dunning_type = 'STAGED_DUNNING';
2522:
2523: CURSOR c_fnd_languages IS
2524: SELECT language_code
2525: FROM fnd_languages
2526: WHERE installed_flag IN ('B','I');
2527:
2528: cursor c_migrated_dunn_letter_sets is
2529: select dnb.dunning_plan_id dunning_plan_id,

Line 2698: FOR fnd_languages IN c_fnd_languages loop

2694: dunn_letter_set_rec.grace_days,
2695: dunn_letter_set_rec.include_unused_payments_flag,
2696: dunn_letter_set_rec.dunning_letter_set_id,
2697: dunn_letter_set_rec.dunning_letter_set_id);
2698: FOR fnd_languages IN c_fnd_languages loop
2699: INSERT INTO IEX_DUNNING_PLANS_TL
2700: (DUNNING_PLAN_ID,
2701: NAME,
2702: DESCRIPTION,

Line 2714: fnd_languages.language_code, --'US',

2710: VALUES
2711: (l_dunning_plan_id,
2712: dunn_letter_set_rec.name,
2713: dunn_letter_set_rec.description,
2714: fnd_languages.language_code, --'US',
2715: 'US',
2716: dunn_letter_set_rec.created_by,
2717: dunn_letter_set_rec.creation_date,
2718: dunn_letter_set_rec.last_update_date,

Line 2721: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Language code ' || fnd_languages.language_code);

2717: dunn_letter_set_rec.creation_date,
2718: dunn_letter_set_rec.last_update_date,
2719: dunn_letter_set_rec.last_updated_by,
2720: dunn_letter_set_rec.last_update_login);
2721: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Language code ' || fnd_languages.language_code);
2722: END LOOP;
2723: l_output_string := ' Dunning_plan_id : ' || rpad(l_dunning_plan_id, 20, ' ') || ' Name: ' || rpad(dunn_letter_set_rec.name, 30, ' ') || ' Description: ' || rpad(dunn_letter_set_rec.description, 50, ' ');
2724: FND_FILE.PUT_LINE(FND_FILE.LOG, l_output_string);
2725: