[Home] [Help]
1274: and cbet.expenditure_type = gbc.expenditure_type
1275: and irs.ind_rate_sch_id = irsr.ind_rate_sch_id
1276: and ics.ind_rate_sch_revision_id = irsr.ind_rate_sch_revision_id
1277: and ics.organization_id = gbc.expenditure_organization_id
1278: and ics.ind_compiled_set_id = gms_cost_plus_extn.AWARD_CMT_COMPILED_SET_ID( gbc.DOCUMENT_HEADER_ID ,
1279: gbc.DOCUMENT_DISTRIBUTION_ID,
1280: gbc.task_id,
1281: gbc.document_type,
1282: gbc.expenditure_item_date,
1397: and irs.ind_rate_sch_id = irsr.ind_rate_sch_id
1398: and ics.ind_rate_sch_revision_id = irsr.ind_rate_sch_revision_id
1399: and ics.organization_id = gbc.expenditure_organization_id
1400: and gbc.document_type = 'EXP'
1401: and ics.ind_compiled_set_id = gms_cost_plus_extn.AWARD_CMT_COMPILED_SET_ID( gbc.DOCUMENT_HEADER_ID ,
1402: gbc.DOCUMENT_DISTRIBUTION_ID,
1403: gbc.task_id,
1404: gbc.document_type,
1405: gbc.expenditure_item_date,
1419:
1420: -- ------------
1421: -- Bug 2143160
1422: -- ------------
1423: gms_cost_plus_extn.update_exp_rev_cat (x_packet_id);
1424:
1425: IF L_DEBUG = 'Y' THEN
1426: gms_error_pkg.gms_debug('GMS :setup_rlmi START TIME :'||to_char(SYSDATE, 'DD-MON-YYYY HH24:MI:SS'), 'C');
1427: END IF;
1434:
1435: -- -----------------
1436: -- Bug 2143160
1437: -- -----------------
1438: gms_cost_plus_extn.update_top_tsk_par_res (x_packet_id);
1439:
1440: x_temp := NULL ;
1441:
1442: IF NVL(x_err_code, 0) <> 0 THEN
2371: and adl.adl_line_num = 1
2372: and rownum = 1;
2373:
2374: END IF ;
2375: gms_cost_plus_extn.get_award_ind_rate_sch_rev_id(l_award_id ,
2376: --Added for Bug 2097676 :Multiple Indirect Cost Schedules build
2377: p_task_id ,
2378: p_exp_item_date ,
2379: x_rate_sch_rev_id,