APPS.IGF_AW_COA_UPDATE dependencies on IGF_AW_COA_RATE_DET

Line 222: FROM igf_aw_coa_rate_det rate

218: c_ci_sequence_number igs_ca_inst.sequence_number%TYPE,
219: c_item_code igf_aw_item.item_code%TYPE
220: ) IS
221: SELECT rate.*
222: FROM igf_aw_coa_rate_det rate
223: WHERE ci_cal_type = c_ci_cal_type
224: AND ci_sequence_number = c_ci_sequence_number
225: AND item_code = c_item_code
226: ORDER BY rate_order_num ASC;

Line 525: FROM igf_aw_coa_rate_det rate

521: cp_ci_sequence_number igs_ca_inst.sequence_number%TYPE,
522: cp_item_code igf_aw_item.item_code%TYPE
523: ) IS
524: SELECT 'X' exist
525: FROM igf_aw_coa_rate_det rate
526: WHERE ci_cal_type = cp_ci_cal_type
527: AND ci_sequence_number = cp_ci_sequence_number
528: AND item_code = cp_item_code
529: AND ROWNUM = 1;