DBA Data[Home] [Help]

APPS.GMS_ENC_ADJUSTMENTS dependencies on PER_ASSIGNMENTS_F

Line 1045: per_assignments_f a,

1041: cursor ORG_CUR is
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