APPS.PA_SELF_SERVICE_MSG_PUB dependencies on PA_EXPENDITURES

Line 92: P_Expenditure_Id IN pa_expenditures_all.expenditure_id%TYPE,

88: -- end if;
89: -- end;
90: --
91: PROCEDURE business_message(
92: P_Expenditure_Id IN pa_expenditures_all.expenditure_id%TYPE,
93: P_Person_id IN per_all_people_f.person_id%TYPE,
94: P_Week_Ending_Date IN Date,
95: X_Msg_Application_Name OUT NOCOPY Fnd_Application.Application_short_name%TYPE, --File.Sql.39 bug 4440895
96: X_Msg_Name OUT NOCOPY Varchar2, --File.Sql.39 bug 4440895

Line 119: from pa_expenditures exp,

115: sum(decode(ei.billable_flag_4,'Y',ei.quantity_4,0)) bill_qty_4,
116: sum(decode(ei.billable_flag_5,'Y',ei.quantity_5,0)) bill_qty_5,
117: sum(decode(ei.billable_flag_6,'Y',ei.quantity_6,0)) bill_qty_6,
118: sum(decode(ei.billable_flag_7,'Y',ei.quantity_7,0)) bill_qty_7
119: from pa_expenditures exp,
120: pa_ei_denorm ei
121: where ei.expenditure_id = exp.expenditure_id
122: and exp.expenditure_id = p_expenditure_id
123: and exp.incurred_by_person_id = p_person_id