APPS.PA_UTILS2 dependencies on PA_EXPENDITURES

Line 1511: From PA_Cost_Distribution_lines CDL,PA_Expenditure_items_all EI,PA_Expenditures EXP

1507: ,p_recvr_sob_id(i))
1508: ,nvl(EI.recvr_org_id,CDL.org_id)) recvr_gl_period_name,
1509: 'Y' -- Interface to GL
1510: Into l_gl_date_new(i) , l_gl_period_new(i) , l_recvr_gl_date_new(i) , l_recvr_gl_period_new(i) , l_interface_to_gl(i)
1511: From PA_Cost_Distribution_lines CDL,PA_Expenditure_items_all EI,PA_Expenditures EXP
1512: Where CDL.Rowid = chartorowid( p_cdl_rowid(i) )
1513: AND CDL.Transfer_Status_Code in ('P','R')
1514: AND CDL.expenditure_item_id = EI.expenditure_item_id
1515: AND EXP.expenditure_id = EI.Expenditure_Id

Line 5282: FROM pa_expenditure_items ei, pa_expenditures e

5278: SELECT DISTINCT
5279: e.expenditure_id,
5280: e.incurred_by_person_id,
5281: e.expenditure_ending_date
5282: FROM pa_expenditure_items ei, pa_expenditures e
5283: WHERE ei.expenditure_id = e.expenditure_id
5284: AND ei.system_linkage_function IN ('ST','OT')
5285: AND ei.Cost_Distributed_Flag = 'S'
5286: AND e.person_type IS NULL

Line 5294: FROM pa_cost_distribution_lines cdl, pa_expenditures e,

5290: SELECT DISTINCT
5291: e.expenditure_id,
5292: e.incurred_by_person_id,
5293: e.expenditure_ending_date
5294: FROM pa_cost_distribution_lines cdl, pa_expenditures e,
5295: pa_expenditure_items ei
5296: WHERE TRUNC(CDL.GL_DATE) <= NVL(gl_date,TRUNC(CDL.GL_DATE))
5297: AND cdl.expenditure_item_id = ei.expenditure_item_id
5298: AND cdl.Transfer_Status_Code IN ('P', 'R', 'X')

Line 5310: FROM pa_cost_distribution_lines cdl, pa_expenditures e,

5306: SELECT DISTINCT
5307: e.expenditure_id,
5308: e.incurred_by_person_id,
5309: e.expenditure_ending_date
5310: FROM pa_cost_distribution_lines cdl, pa_expenditures e,
5311: pa_expenditure_items ei
5312: WHERE cdl.expenditure_item_id = ei.expenditure_item_id
5313: AND cdl.Transfer_Status_Code = 'X'
5314: AND cdl.Line_Type = 'R'

Line 5340: UPDATE pa_expenditures e

5336: IF p_date IS NULL AND p_upd_type IS NULL THEN
5337:
5338: FOR rec IN elg_dist(p_request_id) LOOP
5339:
5340: UPDATE pa_expenditures e
5341: SET person_type = (
5342: SELECT decode(a.assignment_type,'E','EMP','C','CWK')
5343: FROM per_assignment_status_types s
5344: ,per_all_assignments_f a

Line 5366: UPDATE pa_expenditures e

5362: ELSIF p_upd_type = 'A' THEN
5363:
5364: FOR rec1 IN elg_acc1(p_date,p_request_id) LOOP
5365:
5366: UPDATE pa_expenditures e
5367: SET person_type = (
5368: SELECT decode(a.assignment_type,'E','EMP','C','CWK')
5369: FROM per_assignment_status_types s
5370: ,per_all_assignments_f a

Line 5392: UPDATE pa_expenditures e

5388: ELSIF p_upd_type = 'X' THEN
5389:
5390: FOR rec1 IN elg_acc2(p_request_id) LOOP
5391:
5392: UPDATE pa_expenditures e
5393: SET person_type = (
5394: SELECT decode(a.assignment_type,'E','EMP','C','CWK')
5395: FROM per_assignment_status_types s
5396: ,per_all_assignments_f a