APPS.IGF_AP_LI_PROF_IMP_PROC dependencies on IGF_AP_LI_BAT_INTS

Line 2970: -- cursor to get batch desc for the batch id from igf_ap_li_bat_ints

2966: || Who When What
2967: || (reverse chronological order - newest change first)
2968: */
2969:
2970: -- cursor to get batch desc for the batch id from igf_ap_li_bat_ints
2971: CURSOR c_batch_desc(cp_batch_num igf_aw_li_coa_ints.batch_num%TYPE ) IS
2972: SELECT batch_desc, batch_type
2973: FROM igf_ap_li_bat_ints
2974: WHERE batch_num = cp_batch_num ;

Line 2973: FROM igf_ap_li_bat_ints

2969:
2970: -- cursor to get batch desc for the batch id from igf_ap_li_bat_ints
2971: CURSOR c_batch_desc(cp_batch_num igf_aw_li_coa_ints.batch_num%TYPE ) IS
2972: SELECT batch_desc, batch_type
2973: FROM igf_ap_li_bat_ints
2974: WHERE batch_num = cp_batch_num ;
2975:
2976: -- CURSOR FOR GETTING THE MESSAGE FROM FND_NEW_MESSAGES
2977: CURSOR c_get_message(cp_message_name VARCHAR2) IS

Line 2986: l_batch_desc igf_ap_li_bat_ints.batch_desc%TYPE ;

2982: l_delete_flag_prmpt fnd_new_messages.message_text%TYPE;
2983:
2984: l_lkup_type VARCHAR2(60) ;
2985: l_lkup_code VARCHAR2(60) ;
2986: l_batch_desc igf_ap_li_bat_ints.batch_desc%TYPE ;
2987: l_batch_type igf_ap_li_bat_ints.batch_type%TYPE ;
2988: l_batch_id igf_ap_li_bat_ints.batch_type%TYPE ;
2989: l_yes_no igf_lookups_view.meaning%TYPE ;
2990: l_award_year_pmpt igf_lookups_view.meaning%TYPE ;

Line 2987: l_batch_type igf_ap_li_bat_ints.batch_type%TYPE ;

2983:
2984: l_lkup_type VARCHAR2(60) ;
2985: l_lkup_code VARCHAR2(60) ;
2986: l_batch_desc igf_ap_li_bat_ints.batch_desc%TYPE ;
2987: l_batch_type igf_ap_li_bat_ints.batch_type%TYPE ;
2988: l_batch_id igf_ap_li_bat_ints.batch_type%TYPE ;
2989: l_yes_no igf_lookups_view.meaning%TYPE ;
2990: l_award_year_pmpt igf_lookups_view.meaning%TYPE ;
2991: l_params_pass_prmpt igf_lookups_view.meaning%TYPE ;

Line 2988: l_batch_id igf_ap_li_bat_ints.batch_type%TYPE ;

2984: l_lkup_type VARCHAR2(60) ;
2985: l_lkup_code VARCHAR2(60) ;
2986: l_batch_desc igf_ap_li_bat_ints.batch_desc%TYPE ;
2987: l_batch_type igf_ap_li_bat_ints.batch_type%TYPE ;
2988: l_batch_id igf_ap_li_bat_ints.batch_type%TYPE ;
2989: l_yes_no igf_lookups_view.meaning%TYPE ;
2990: l_award_year_pmpt igf_lookups_view.meaning%TYPE ;
2991: l_params_pass_prmpt igf_lookups_view.meaning%TYPE ;
2992: l_person_number_prmpt igf_lookups_view.meaning%TYPE ;