DBA Data[Home] [Help]

APPS.PA_SELF_SERVICE_MSG_PUB dependencies on PA_EI_DENORM

Line 120: pa_ei_denorm ei

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
124: and exp.expenditure_ending_date = p_week_ending_date;