APPS.GMS_BUDGET_BALANCE dependencies on PA_EXPENDITURES_ALL

Line 638: PA_EXPENDITURES_ALL PA,

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
642: AND ADL.ADL_STATUS = 'A'

Line 659: pa_expenditures_all pa,

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
663: gms_award_distributions adl,

Line 1473: FROM pa_expenditures_all exp,

1469: SELECT DISTINCT EXP.incurred_by_person_id,
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

Line 1516: FROM pa_expenditures_all exp,

1512: INTO x_person_id,
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