DBA Data[Home] [Help]

APPS.PA_GL_REV_XFER_AUDIT_PKG dependencies on PER_PEOPLE_F

Line 349: per_people_f emp,

345:
346: update pa_gl_rev_xfer_audit_rep rep set (TRANSACTION_TYPE,TRANSACTION_DATE,TASK_ID,EMP_OR_ORG_NAME) =
347: (select ei.expenditure_type,ei.expenditure_item_date,ei.task_id,DECODE(emp.full_name, null,org.name, emp.full_name )
348: from hr_organization_units org,
349: per_people_f emp,
350: pa_expenditure_items_all ei,
351: pa_expenditures_all exp
352: where ei.expenditure_item_id = rep.expenditure_item_id
353: AND ei.expenditure_id = exp.expenditure_id