DBA Data[Home] [Help]

APPS.PA_GL_REV_XFER_AUDIT_PKG dependencies on HR_ORGANIZATION_UNITS

Line 350: from hr_organization_units org,

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