APPS.IGF_AP_LG_COA_IMP dependencies on IGF_AP_LI_BAT_INTS

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

24: || Who When What
25: || (reverse chronological order - newest change first)
26: */
27:
28: -- cursor to get batch desc for the batch id from igf_ap_li_bat_ints
29: CURSOR c_batch_desc(cp_batch_num igf_aw_li_coa_ints.batch_num%TYPE ) IS
30: SELECT batch_desc, batch_type
31: FROM igf_ap_li_bat_ints
32: WHERE batch_num = cp_batch_num ;

Line 31: FROM igf_ap_li_bat_ints

27:
28: -- cursor to get batch desc for the batch id from igf_ap_li_bat_ints
29: CURSOR c_batch_desc(cp_batch_num igf_aw_li_coa_ints.batch_num%TYPE ) IS
30: SELECT batch_desc, batch_type
31: FROM igf_ap_li_bat_ints
32: WHERE batch_num = cp_batch_num ;
33:
34: l_lkup_type VARCHAR2(60) ;
35: l_lkup_code VARCHAR2(60) ;

Line 36: l_batch_desc igf_ap_li_bat_ints.batch_desc%TYPE ;

32: WHERE batch_num = cp_batch_num ;
33:
34: l_lkup_type VARCHAR2(60) ;
35: l_lkup_code VARCHAR2(60) ;
36: l_batch_desc igf_ap_li_bat_ints.batch_desc%TYPE ;
37: l_batch_type igf_ap_li_bat_ints.batch_type%TYPE ;
38: l_batch_id igf_ap_li_bat_ints.batch_type%TYPE ;
39: l_yes_no igf_lookups_view.meaning%TYPE ;
40: l_award_year_pmpt igf_lookups_view.meaning%TYPE ;

Line 37: l_batch_type igf_ap_li_bat_ints.batch_type%TYPE ;

33:
34: l_lkup_type VARCHAR2(60) ;
35: l_lkup_code VARCHAR2(60) ;
36: l_batch_desc igf_ap_li_bat_ints.batch_desc%TYPE ;
37: l_batch_type igf_ap_li_bat_ints.batch_type%TYPE ;
38: l_batch_id igf_ap_li_bat_ints.batch_type%TYPE ;
39: l_yes_no igf_lookups_view.meaning%TYPE ;
40: l_award_year_pmpt igf_lookups_view.meaning%TYPE ;
41: l_params_pass_prmpt igf_lookups_view.meaning%TYPE ;

Line 38: l_batch_id igf_ap_li_bat_ints.batch_type%TYPE ;

34: l_lkup_type VARCHAR2(60) ;
35: l_lkup_code VARCHAR2(60) ;
36: l_batch_desc igf_ap_li_bat_ints.batch_desc%TYPE ;
37: l_batch_type igf_ap_li_bat_ints.batch_type%TYPE ;
38: l_batch_id igf_ap_li_bat_ints.batch_type%TYPE ;
39: l_yes_no igf_lookups_view.meaning%TYPE ;
40: l_award_year_pmpt igf_lookups_view.meaning%TYPE ;
41: l_params_pass_prmpt igf_lookups_view.meaning%TYPE ;
42: l_person_number_prmpt igf_lookups_view.meaning%TYPE ;