DBA Data[Home] [Help]

APPS.JA_CN_FA_ACUI_EXPORT_PKG dependencies on FND_PROFILE

Line 368: fnd_profile.value('PER_BUSINESS_GROUP_ID')

364: AND pos.period_of_service_id = paf.period_of_service_id
365: AND paf.person_id = ppf.person_id
366: AND paf.person_id = fdh.assigned_to
367: AND ppf.business_group_id =
368: fnd_profile.value('PER_BUSINESS_GROUP_ID')
369: AND paf.business_group_id =
370: fnd_profile.value('PER_BUSINESS_GROUP_ID')
371: AND paf.primary_flag = 'Y'
372: GROUP BY paf.organization_id

Line 370: fnd_profile.value('PER_BUSINESS_GROUP_ID')

366: AND paf.person_id = fdh.assigned_to
367: AND ppf.business_group_id =
368: fnd_profile.value('PER_BUSINESS_GROUP_ID')
369: AND paf.business_group_id =
370: fnd_profile.value('PER_BUSINESS_GROUP_ID')
371: AND paf.primary_flag = 'Y'
372: GROUP BY paf.organization_id
373: UNION
374: SELECT SUM(fdh.units_assigned), fdh.assigned_to