APPS.IGF_AW_COA_GEN dependencies on IGF_AW_COA_ITM_TERMS

Line 47: FROM igf_aw_coa_itm_terms coa,

43: cp_awd_prd_code igf_aw_award_prd.award_prd_cd%TYPE,
44: cp_use_direct_costs igf_aw_coa_items.fixed_cost%TYPE
45: ) IS
46: SELECT SUM(coa.amount)
47: FROM igf_aw_coa_itm_terms coa,
48: igf_aw_awd_prd_term trms,
49: igf_ap_fa_base_rec_all fa,
50: igf_aw_coa_items item
51: WHERE fa.base_id = coa.base_id

Line 72: FROM igf_aw_coa_itm_terms coa,

68: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
69: cp_use_direct_costs igf_aw_coa_items.fixed_cost%TYPE
70: ) IS
71: SELECT SUM(coa.amount)
72: FROM igf_aw_coa_itm_terms coa,
73: igf_aw_coa_items item
74: WHERE coa.base_id = cp_base_id
75: AND item.base_id = coa.base_id
76: AND item.item_code = coa.item_code

Line 223: FROM igf_aw_coa_itm_terms

219: cp_ld_cal_type igs_ca_inst.cal_type%TYPE,
220: cp_ld_sequence_number igs_ca_inst.sequence_number%TYPE
221: ) IS
222: SELECT NVL(lock_flag,'N') lock_flag
223: FROM igf_aw_coa_itm_terms
224: WHERE base_id = cp_base_id
225: AND item_code = cp_item_code
226: AND ld_cal_type = cp_ld_cal_type
227: AND ld_sequence_number = cp_ld_sequence_number;

Line 437: FROM igf_aw_coa_itm_terms terms

433: cp_ld_sequence_number igs_ca_inst.sequence_number%TYPE
434: ) IS
435: SELECT terms.rowid row_id,
436: terms.*
437: FROM igf_aw_coa_itm_terms terms
438: WHERE base_id = cp_base_id
439: AND item_code = cp_item_code
440: AND ld_cal_type = cp_ld_cal_type
441: AND ld_sequence_number = cp_ld_sequence_number;

Line 470: FROM igf_aw_coa_itm_terms terms

466: cp_item_code igf_aw_item.item_code%TYPE
467: ) IS
468: SELECT terms.ld_cal_type,
469: terms.ld_sequence_number
470: FROM igf_aw_coa_itm_terms terms
471: WHERE base_id = cp_base_id
472: AND item_code = cp_item_code;
473:
474:

Line 514: igf_aw_coa_itm_terms_pkg.update_row(

510: fnd_message.set_token('TERM',igf_gr_gen.get_alt_code(p_ld_cal_type,p_ld_sequence_number));
511: fnd_file.put_line(fnd_file.log,RPAD(' ',8)||fnd_message.get);
512:
513:
514: igf_aw_coa_itm_terms_pkg.update_row(
515: x_rowid => l_item_term.row_id,
516: x_base_id => l_item_term.base_id,
517: x_item_code => l_item_term.item_code,
518: x_amount => l_item_term.amount,

Line 735: igf_aw_coa_itm_terms_pkg.update_row(

731: fnd_message.set_token('TERM',igf_gr_gen.get_alt_code(p_ld_cal_type,p_ld_sequence_number));
732: fnd_file.put_line(fnd_file.log,RPAD(' ',4)||fnd_message.get);
733:
734:
735: igf_aw_coa_itm_terms_pkg.update_row(
736: x_rowid => l_item_term.row_id,
737: x_base_id => l_item_term.base_id,
738: x_item_code => l_item_term.item_code,
739: x_amount => l_item_term.amount,

Line 1071: igf_aw_coa_itm_terms coa

1067: SELECT coa.ld_cal_type,
1068: coa.ld_sequence_number
1069: FROM igf_aw_awd_prd_term ap,
1070: igf_ap_fa_base_rec_all fa,
1071: igf_aw_coa_itm_terms coa
1072: WHERE fa.base_id = cp_base_id
1073: AND fa.ci_cal_type = ap.ci_cal_type
1074: AND fa.ci_sequence_number = ap.ci_sequence_number
1075: AND coa.base_id = cp_base_id

Line 1086: FROM igf_aw_coa_itm_terms coa

1082: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE
1083: ) IS
1084: SELECT coa.ld_cal_type,
1085: coa.ld_sequence_number
1086: FROM igf_aw_coa_itm_terms coa
1087: WHERE coa.base_id = cp_base_id
1088: GROUP BY coa.ld_cal_type,coa.ld_sequence_number;
1089:
1090: CURSOR get_round_off(