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_TIME_CLIENT_EXTN dependencies on PA_EXPENDITURES

Line 42: FROM PA_EXPENDITURES

38: --
39:
40: cursor c_user_batch_name is
41: SELECT user_batch_name
42: FROM PA_EXPENDITURES
43: WHERE incurred_by_organization_id =
44: p_expenditure_organization_id
45: AND trunc(Expenditure_ending_date) = p_expenditure_ending_date
46: AND expenditure_id = p_expenditure_id;

Line 228: -- Incurred_By_Person_Id Pa_Expenditures_All.Incurred_By_Person_Id%TYPE,

224: -- Task_Id Pa_Tasks.Task_Id%TYPE,
225: -- Expenditure_Type Pa_Expenditure_Types.Expenditure_Type%TYPE,
226: -- System_Linkage_Function Pa_System_Linkages.Function%TYPE,
227: -- Quantity Pa_Expenditure_Items_All.quantity%TYPE,
228: -- Incurred_By_Person_Id Pa_Expenditures_All.Incurred_By_Person_Id%TYPE,
229: -- Override_Approver_Person_Id Pa_Expenditures_All.Overriding_Approver_Person_Id%TYPE,
230: -- Expenditure_Item_Date Pa_Expenditure_Items_All.Expenditure_Item_Date%TYPE,
231: -- Exp_Ending_Date Pa_Expenditures_All.Expenditure_Ending_Date%TYPE,
232: -- Attribute_Category Pa_Expenditure_Items_All.Attribute_Category%TYPE,

Line 229: -- Override_Approver_Person_Id Pa_Expenditures_All.Overriding_Approver_Person_Id%TYPE,

225: -- Expenditure_Type Pa_Expenditure_Types.Expenditure_Type%TYPE,
226: -- System_Linkage_Function Pa_System_Linkages.Function%TYPE,
227: -- Quantity Pa_Expenditure_Items_All.quantity%TYPE,
228: -- Incurred_By_Person_Id Pa_Expenditures_All.Incurred_By_Person_Id%TYPE,
229: -- Override_Approver_Person_Id Pa_Expenditures_All.Overriding_Approver_Person_Id%TYPE,
230: -- Expenditure_Item_Date Pa_Expenditure_Items_All.Expenditure_Item_Date%TYPE,
231: -- Exp_Ending_Date Pa_Expenditures_All.Expenditure_Ending_Date%TYPE,
232: -- Attribute_Category Pa_Expenditure_Items_All.Attribute_Category%TYPE,
233: -- Attribute1 Pa_Expenditure_Items_All.Attribute1%TYPE,

Line 231: -- Exp_Ending_Date Pa_Expenditures_All.Expenditure_Ending_Date%TYPE,

227: -- Quantity Pa_Expenditure_Items_All.quantity%TYPE,
228: -- Incurred_By_Person_Id Pa_Expenditures_All.Incurred_By_Person_Id%TYPE,
229: -- Override_Approver_Person_Id Pa_Expenditures_All.Overriding_Approver_Person_Id%TYPE,
230: -- Expenditure_Item_Date Pa_Expenditure_Items_All.Expenditure_Item_Date%TYPE,
231: -- Exp_Ending_Date Pa_Expenditures_All.Expenditure_Ending_Date%TYPE,
232: -- Attribute_Category Pa_Expenditure_Items_All.Attribute_Category%TYPE,
233: -- Attribute1 Pa_Expenditure_Items_All.Attribute1%TYPE,
234: -- Attribute2 Pa_Expenditure_Items_All.Attribute1%TYPE,
235: -- Attribute3 Pa_Expenditure_Items_All.Attribute1%TYPE,

Line 245: -- Orig_Exp_Txn_Reference1 Pa_Expenditures_All.Orig_Exp_Txn_Reference1%TYPE)

241: -- Attribute9 Pa_Expenditure_Items_All.Attribute1%TYPE,
242: -- Attribute10 Pa_Expenditure_Items_All.Attribute1%TYPE,
243: -- Billable_Flag Pa_Expenditure_Items_All.Billable_Flag%TYPE,
244: -- Expenditure_Item_Comment Pa_Expenditure_Comments.Expenditure_Comment%TYPE,
245: -- Orig_Exp_Txn_Reference1 Pa_Expenditures_All.Orig_Exp_Txn_Reference1%TYPE)
246: --
247: -- The following pl/sql table columns will always be NULL:
248: -- Orig_Exp_Txn_Reference1
249: --

Line 306: P_Expenditure_Id IN pa_expenditures_all.expenditure_id%TYPE DEFAULT NULL,

302: --
303: PROCEDURE Display_Business_Message(
304: P_Timecard_Table IN Pa_Otc_Api.Timecard_Table,
305: P_Module IN VARCHAR2,
306: P_Expenditure_Id IN pa_expenditures_all.expenditure_id%TYPE DEFAULT NULL,
307: P_Person_id IN per_all_people_f.person_id%TYPE,
308: P_Week_Ending_Date IN Date,
309: X_Msg_Application_Name OUT NOCOPY Fnd_Application.Application_short_name%TYPE,
310: X_Message_data OUT NOCOPY Varchar2,

Line 335: -- from pa_expenditures exp,

331: -- sum(decode(ei.billable_flag_4,'Y',ei.quantity_4,0)) bill_qty_4,
332: -- sum(decode(ei.billable_flag_5,'Y',ei.quantity_5,0)) bill_qty_5,
333: -- sum(decode(ei.billable_flag_6,'Y',ei.quantity_6,0)) bill_qty_6,
334: -- sum(decode(ei.billable_flag_7,'Y',ei.quantity_7,0)) bill_qty_7
335: -- from pa_expenditures exp,
336: -- pa_ei_denorm ei
337: -- where ei.expenditure_id = exp.expenditure_id
338: -- and exp.expenditure_id = p_expenditure_id
339: -- and exp.incurred_by_person_id = p_person_id