DBA Data[Home] [Help]

APPS.GMS_ENC_ADJUSTMENTS dependencies on HR_ORGANIZATION_UNITS

Line 1046: hr_organization_units o

1042: select o.organization_id,
1043: o.name
1044: from pa_employees p,
1045: per_assignments_f a,
1046: hr_organization_units o
1047: where a.person_id = p.person_id
1048: and a.effective_start_date <= p_week_end_date
1049: and nvl(a.effective_end_date,p_week_end_date) >= p_week_end_date - 6
1050: and a.primary_flag = 'Y'