DBA Data[Home] [Help]

APPS.PA_ACC_GEN_WF_PKG dependencies on FINANCIALS_SYSTEM_PARAMETERS

Line 276: FROM financials_system_parameters fsp)

272: per_assignments_f a,
273: per_assignment_status_types past
274: WHERE p.person_id = p_employee_id
275: AND p.business_group_id + 0 = (SELECT nvl(max(fsp.business_group_id),0)
276: FROM financials_system_parameters fsp)
277: AND a.person_id = p.person_id
278: AND a.primary_flag = 'Y'
279: AND TRUNC(l_person_effective_date) BETWEEN p.effective_start_date and p.effective_end_date
280: AND TRUNC(l_person_effective_date) BETWEEN a.effective_start_date and a.effective_end_date