APPS.IGF_AW_GEN_004 dependencies on IGF_AP_MIS_ITMS_LTR_V

Line 264: l_award_year igf_ap_mis_itms_ltr_v.award_year%TYPE;

260: p_select_type IN VARCHAR2,
261: p_sql_stmt OUT NOCOPY VARCHAR2
262: ) IS
263:
264: l_award_year igf_ap_mis_itms_ltr_v.award_year%TYPE;
265: BEGIN
266:
267: /*************************************************************
268: Created By :Prajeesh

Line 304: fnd_dsql.add_text(' IGF_AP_MIS_ITMS_LTR_V WHERE person_id IN (select column_value from table(igf_aw_gen_004.get_person_id())');

300: fnd_dsql.add_text(' IGF_AW_PER_LIST_V WHERE person_id IN (select column_value from table(igf_aw_gen_004.get_person_id())');
301: fnd_dsql.add_text(') AND award_year =');
302: fnd_dsql.add_bind(l_award_year);
303: ELSIF p_sys_ltr_code='FAMISTM' THEN
304: fnd_dsql.add_text(' IGF_AP_MIS_ITMS_LTR_V WHERE person_id IN (select column_value from table(igf_aw_gen_004.get_person_id())');
305: fnd_dsql.add_text(') AND award_year =');
306: fnd_dsql.add_bind(l_award_year);
307: ELSIF p_sys_ltr_code='FADISBT' THEN
308: fnd_dsql.add_text(' IGF_SL_DISB_LTR_V WHERE person_id IN (select column_value from table(igf_aw_gen_004.get_person_id())');