eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_BURDEN_COSTING dependencies on GMS_AWARD_DISTRIBUTIONS

Line 876: from gms_award_distributions adl

872: and ei.project_id = current_project_id
873: and ei.expenditure_item_id = cdl.expenditure_item_id
874: and ei.expenditure_item_date <= nvl(l_end_date,ei.expenditure_item_date))
875: and exists (select null
876: from gms_award_distributions adl
877: where adl.expenditure_item_id = cdl.expenditure_item_id
878: and adl.cdl_line_num = cdl.line_num
879: and adl.adl_status = 'A'
880: and adl.document_type = 'EXP')

Line 1317: from gms_award_distributions adl

1313: and ei.expenditure_item_date <= l_end_date
1314: )
1315: and exists
1316: (select null
1317: from gms_award_distributions adl
1318: where adl.expenditure_item_id = cdl.expenditure_item_id
1319: and adl.cdl_line_num = cdl.line_num
1320: and adl.adl_status = 'A'
1321: and adl.document_type = 'EXP')

Line 1360: from gms_award_distributions adl

1356: and cdl.burden_sum_source_run_id = init_cdl_run_id
1357: and cdl.project_id = current_project_id
1358: and exists
1359: (select null
1360: from gms_award_distributions adl
1361: where adl.expenditure_item_id = cdl.expenditure_item_id
1362: and adl.cdl_line_num = cdl.line_num
1363: and adl.adl_status = 'A'
1364: and adl.document_type = 'EXP')

Line 1431: from gms_award_distributions adl

1427: and cdl1.burden_sum_rejection_code is NULL /*3071338*/
1428: and cdl1.expenditure_item_id= cdl.expenditure_item_id)
1429: and exists
1430: (select null
1431: from gms_award_distributions adl
1432: where adl.expenditure_item_id = cdl.expenditure_item_id
1433: and adl.cdl_line_num = cdl.line_num
1434: and adl.adl_status = 'A'
1435: and adl.document_type = 'EXP');