DBA Data[Home] [Help]

APPS.JA_CN_HRMS_EXPORT_PKG dependencies on FND_PROFILE

Line 284: AND org.business_group_id = fnd_profile.VALUE('PER_BUSINESS_GROUP_ID')

280: NULL PARENT_DEPARTMENT_ID
281: FROM hr_organization_units org, hr_all_organization_units_tl orgtl
282: WHERE orgtl.organization_id = org.organization_id
283: AND orgtl.LANGUAGE = userenv('LANG')
284: AND org.business_group_id = fnd_profile.VALUE('PER_BUSINESS_GROUP_ID')
285: AND date_from <= pd_acc_end_date
286: AND nvl(date_to,
287: pd_acc_end_date) >= pd_acc_start_date
288: AND EXISTS (SELECT 1

Line 515: AND ppf.business_group_id = fnd_profile.value('PER_BUSINESS_GROUP_ID')

511: ( SELECT MAX(ppos.period_of_service_id)
512: FROM per_periods_of_service ppos
513: WHERE ppos.person_id = ppf.person_id)
514: )
515: AND ppf.business_group_id = fnd_profile.value('PER_BUSINESS_GROUP_ID')
516: AND paf.business_group_id = fnd_profile.value('PER_BUSINESS_GROUP_ID');
517:
518: BEGIN
519: --logging for debug

Line 516: AND paf.business_group_id = fnd_profile.value('PER_BUSINESS_GROUP_ID');

512: FROM per_periods_of_service ppos
513: WHERE ppos.person_id = ppf.person_id)
514: )
515: AND ppf.business_group_id = fnd_profile.value('PER_BUSINESS_GROUP_ID')
516: AND paf.business_group_id = fnd_profile.value('PER_BUSINESS_GROUP_ID');
517:
518: BEGIN
519: --logging for debug
520: IF (ln_proc_level >= ln_dbg_level)