APPS.IGF_AW_GEN_004 dependencies on IGF_AW_AWD_LTR_TMP

Line 1201: igf_aw_awd_ltr_tmp lttmp

1197:
1198: /*get the rowid for the person in temp table for deletion*/
1199: CURSOR get_pers_del IS
1200: SELECT lttmp.rowid row_id FROM
1201: igf_aw_awd_ltr_tmp lttmp
1202: WHERE
1203: person_id = p_person_id AND
1204: ci_cal_type = RTRIM (SUBSTR (p_param1, 1, 10)) AND
1205: ci_sequence_number = TO_NUMBER (RTRIM (SUBSTR (p_param1, 11)));

Line 1227: igf_aw_awd_ltr_tmp_pkg.delete_row (

1223: LOOP
1224: FETCH get_pers_del INTO l_get_pers_del;
1225: EXIT WHEN get_pers_del%NOTFOUND;
1226:
1227: igf_aw_awd_ltr_tmp_pkg.delete_row (
1228: x_rowid => l_get_pers_del.row_id
1229: );
1230: END LOOP;
1231: CLOSE get_pers_del;

Line 1235: igf_aw_awd_ltr_tmp_pkg.insert_row (

1231: CLOSE get_pers_del;
1232:
1233: FOR get_award_data_rec IN get_awd_data
1234: LOOP
1235: igf_aw_awd_ltr_tmp_pkg.insert_row (
1236: x_rowid => l_rowid,
1237: x_line_id => get_awd_data%ROWCOUNT,
1238: x_person_id => p_person_id,
1239: x_fund_code => get_award_data_rec.fund_code,

Line 2088: FROM igf_aw_awd_ltr_tmp lt,

2084: SELECT DECODE (lt.fund_description,
2085: 'Award Type', '',
2086: '-', '

' || lt.fund_description || '

Award Message

',
2087: '' || NVL (lt.fund_description, '-') || '' || NVL (fmast.awd_notice_txt, '-') || '') award_description
2088: FROM igf_aw_awd_ltr_tmp lt,
2089: igf_aw_fund_mast_all fmast
2090: WHERE lt.fund_code = fmast.fund_code(+)
2091: AND lt.ci_cal_type = fmast.ci_cal_type(+)
2092: AND lt.ci_sequence_number = fmast.ci_sequence_number(+)