APPS.PA_CALC_OVERTIME dependencies on PA_EXPENDITURES

Line 62: pa_expenditures ex

58: BEGIN
59: SELECT job_id
60: INTO Job_Id
61: FROM per_assignments_f a,
62: pa_expenditures ex
63: WHERE ex.expenditure_id = X_expenditure_id
64: AND a.person_id = ex.incurred_by_person_id
65: AND (a.assignment_type = 'E' OR a.assignment_type = 'C')
66: AND a.primary_flag = 'Y'

Line 85: pa_expenditures ex

81: */
82: SELECT job_id
83: INTO Job_Id
84: FROM per_assignments_f a,
85: pa_expenditures ex
86: WHERE ex.expenditure_id = X_expenditure_id
87: AND a.person_id = ex.incurred_by_person_id
88: AND (a.assignment_type = 'E' OR a.assignment_type = 'C')
89: AND a.primary_flag = 'Y'

Line 115: ,pa_expenditures e

111: BEGIN
112: FOR c IN
113: (select expenditure_item_id
114: from pa_expenditure_items i
115: ,pa_expenditures e
116: where i.system_linkage_function ||'' = 'OT'
117: and i.expenditure_id = e.expenditure_id
118: and e.incurred_by_person_id = R_Person_Id
119: and e.expenditure_ending_date = R_Expenditure_End_Date

Line 246: ,pa_expenditures e

242: ,i.tp_amt_type_code X_tp_amt_type_code
243: ,i.project_raw_cost* -1 x_project_raw_cost
244: ,i.project_burdened_cost* -1 x_project_burdened_cost
245: from pa_expenditure_items i
246: ,pa_expenditures e
247: where i.system_linkage_function ||'' = 'OT'
248: and i.expenditure_id = e.expenditure_id
249: and e.incurred_by_person_id = R_Person_Id
250: and e.expenditure_ending_date = R_Expenditure_End_Date

Line 419: select PA_EXPENDITURES_S.NEXTVAL INTO Expenditure_ID FROM sys.dual;

415: END IF;
416:
417: IF Exp_Created_Flag <> 'Y' THEN
418: -- Sel_Expenditure_ID()
419: select PA_EXPENDITURES_S.NEXTVAL INTO Expenditure_ID FROM sys.dual;
420:
421: Pa_Transactions.InsertExp(
422: X_expenditure_id => Expenditure_ID,
423: X_expend_status => 'APPROVED',

Line 828: PA_Expenditures EXP2

824: '7',ITEM2.Quantity,0))
825: INTO Total_Hours, Sunday, Monday, Tuesday, Wednesday,
826: Thursday, Friday, Saturday
827: FROM PA_Expenditure_Items ITEM2,
828: PA_Expenditures EXP2
829: WHERE EXP2.Incurred_By_Person_ID = R_Person_ID
830: AND EXP2.Expenditure_Ending_Date = R_Expenditure_End_Date
831: AND EXP2.Expenditure_Status_Code||'' = 'APPROVED'
832: AND EXP2.Expenditure_ID = ITEM2.Expenditure_ID

Line 858: ,PA_expenditures EXP

854: Existing_Uncomp_Time_Hours,
855: Existing_Extra_OT_Hours_1,
856: Existing_Extra_OT_Hours_2
857: FROM PA_expenditure_items ITEM
858: ,PA_expenditures EXP
859: WHERE EXP.Incurred_By_Person_Id = R_Person_Id
860: AND EXP.Expenditure_Ending_Date = R_Expenditure_End_Date
861: AND ITEM.Expenditure_Id = EXP.Expenditure_Id
862: AND ITEM.Expenditure_Item_Date = R_Expenditure_End_Date