APPS.GMS_BUDGET_BALANCE dependencies on PA_EXPENDITURE_ITEMS_ALL

Line 637: PA_EXPENDITURE_ITEMS_ALL PE,

633: gl_sets_of_books glsob and pa_implementations imp for bug# 6043224 */
634: FROM GMS_AWARD_DISTRIBUTIONS ADL,
635: PA_COST_DISTRIBUTION_LINES_ALL PC,
636: GL_PERIOD_STATUSES GL,
637: PA_EXPENDITURE_ITEMS_ALL PE,
638: PA_EXPENDITURES_ALL PA,
639: PA_EXPENDITURE_TYPES PET
640: WHERE ADL.PROJECT_ID = x_project_id
641: AND ADL.AWARD_ID = x_award_id

Line 658: from pa_expenditure_items_all pe,

654: AND PE.EXPENDITURE_ITEM_ID = ADL.EXPENDITURE_ITEM_ID
655: AND PA.EXPENDITURE_ID = PE.EXPENDITURE_ID
656: AND PET.EXPENDITURE_TYPE = PE.EXPENDITURE_TYPE;
657: /* Commented for Bug 6043224
658: from pa_expenditure_items_all pe,
659: pa_expenditures_all pa,
660: pa_cost_distribution_lines_all pc,
661: gl_period_STATUSES gl,
662: -- pa_tasks task, -- commented for Bug:1703510

Line 1087: pa_expenditure_items_all ei, --Bug Fix 1482377

1083: --pa_ind_rate_schedules_all_bg irs, --Bug 3630704 : Performance fix
1084: pa_cost_base_cost_codes cbcc , /* added for bug 5689194 */
1085: --pa_ind_compiled_sets ics, /* commented for bug 5689194 */
1086: pa_compiled_multipliers cm,
1087: pa_expenditure_items_all ei, --Bug Fix 1482377
1088: pa_transaction_sources pts, --Bug Fix 1482377
1089: gms_bc_packets gbc
1090: where gbc.document_type = 'EXP'
1091: and cbcc.cost_plus_structure = cbet.cost_plus_structure -- Bug 5689194

Line 1381: pa_expenditure_items_all ei

1377: from gms_bc_packets gms,
1378: gms_budget_versions bv,
1379: pa_budget_entry_methods pm,
1380: pa_expenditure_types TYPE,
1381: pa_expenditure_items_all ei
1382: where gms.packet_id = x_packet_id
1383: and gms.budget_version_id = bv.budget_version_id
1384: and gms.document_type = 'EXP'
1385: and bv.budget_entry_method_code = pm.budget_entry_method_code

Line 1474: pa_expenditure_items_all item,

1470: item.job_id
1471: INTO x_person_id,
1472: x_job_id
1473: FROM pa_expenditures_all exp,
1474: pa_expenditure_items_all item,
1475: gms_bc_packets bc
1476: WHERE bc.packet_id = x_packet_id
1477: AND bc.bc_packet_id = x_bc_packet_id
1478: AND bc.document_header_id = item.expenditure_item_id

Line 1517: pa_expenditure_items_all item,

1513: x_job_id,
1514: x_non_labor_resource,
1515: x_non_labor_resource_org_id
1516: FROM pa_expenditures_all exp,
1517: pa_expenditure_items_all item,
1518: gms_bc_packets bc
1519: WHERE bc.packet_id = x_packet_id
1520: AND bc.bc_packet_id = x_bc_packet_id
1521: AND bc.document_header_id = item.expenditure_item_id