APPS.IGS_AD_IMP_OFF_RESP_DATA dependencies on FND_CONCURRENT_PROGRAMS_VL

Line 970: CURSOR get_conc_desctiption(l_name fnd_concurrent_programs_vl.concurrent_program_name%TYPE) IS

966: FROM igs_ad_offresp_int
967: WHERE batch_id = p_batch_id AND
968: status IN ('2','3');
969:
970: CURSOR get_conc_desctiption(l_name fnd_concurrent_programs_vl.concurrent_program_name%TYPE) IS
971: SELECT description
972: FROM fnd_concurrent_programs_vl
973: WHERE concurrent_program_name = l_name;
974:

Line 972: FROM fnd_concurrent_programs_vl

968: status IN ('2','3');
969:
970: CURSOR get_conc_desctiption(l_name fnd_concurrent_programs_vl.concurrent_program_name%TYPE) IS
971: SELECT description
972: FROM fnd_concurrent_programs_vl
973: WHERE concurrent_program_name = l_name;
974:
975: l_completed_flag VARCHAR2(1) ;
976: v_message_name VARCHAR2(30) ;

Line 988: l_conc_description fnd_concurrent_programs_vl.description%TYPE;

984: l_acaiv_rec cur_ad_ps_appl_inst%ROWTYPE;
985: l_appl_rec igs_ad_appl_all%ROWTYPE;
986: l_calc_actual_ofr_resp_dt igs_ad_offresp_int.actual_offer_response_dt%TYPE;
987: l_offresp_id igs_ad_offresp_int.offresp_int_id%TYPE;
988: l_conc_description fnd_concurrent_programs_vl.description%TYPE;
989: l_space_string VARCHAR2(300);
990:
991:
992: l_gather_status VARCHAR2(5);