eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OTA_MANDATORY_ENROLL_UTIL dependencies on FND_PROFILE

Line 413: AND ( (nvl(fnd_profile.value('OTA_ALLOW_FUTURE_ENDDATED_EMP_ENROLLMENTS'),'N') = 'Y'

409: ,per_business_groups pbg
410: WHERE ppf.person_id = paf.person_id
411: AND (pts.system_person_type IN ('EMP','CWK') OR (paf.assignment_type = 'A' AND pts.system_person_type ='APL'))
412: AND trunc(sysdate) BETWEEN ppf.effective_start_date AND ppf.effective_end_date
413: AND ( (nvl(fnd_profile.value('OTA_ALLOW_FUTURE_ENDDATED_EMP_ENROLLMENTS'),'N') = 'Y'
414: AND trunc(sysdate) BETWEEN paf.effective_start_date and paf.effective_end_date)
415: OR nvl(p_event_start_date, trunc(sysdate)) between paf.effective_start_date and paf.effective_end_date )
416: AND ( (nvl(fnd_profile.value('OTA_ALLOW_FUTURE_ENDDATED_EMP_ENROLLMENTS'),'N') = 'Y'
417: AND trunc(sysdate) BETWEEN ptu.effective_start_date and ptu.effective_end_date)

Line 416: AND ( (nvl(fnd_profile.value('OTA_ALLOW_FUTURE_ENDDATED_EMP_ENROLLMENTS'),'N') = 'Y'

412: AND trunc(sysdate) BETWEEN ppf.effective_start_date AND ppf.effective_end_date
413: AND ( (nvl(fnd_profile.value('OTA_ALLOW_FUTURE_ENDDATED_EMP_ENROLLMENTS'),'N') = 'Y'
414: AND trunc(sysdate) BETWEEN paf.effective_start_date and paf.effective_end_date)
415: OR nvl(p_event_start_date, trunc(sysdate)) between paf.effective_start_date and paf.effective_end_date )
416: AND ( (nvl(fnd_profile.value('OTA_ALLOW_FUTURE_ENDDATED_EMP_ENROLLMENTS'),'N') = 'Y'
417: AND trunc(sysdate) BETWEEN ptu.effective_start_date and ptu.effective_end_date)
418: OR nvl(p_event_start_date, trunc(sysdate)) between ptu.effective_start_date and ptu.effective_end_date )
419: AND paf.job_id = pjt.job_id(+)
420: AND pjt.language(+) = USERENV('LANG')

Line 430: AND (fnd_profile.value('OTA_HR_GLOBAL_BUSINESS_GROUP_ID') IS NOT NULL OR pbg.business_group_id = fnd_profile.value('PER_BUSINESS_GROUP_ID'))

426: AND paf.organization_id = orgtl.organization_id
427: AND pts.system_person_type IN ('EMP', 'CWK', 'APL')
428: AND paf.assignment_type IN ('A','E','C')
429: AND orgtl.language = USERENV('LANG')
430: AND (fnd_profile.value('OTA_HR_GLOBAL_BUSINESS_GROUP_ID') IS NOT NULL OR pbg.business_group_id = fnd_profile.value('PER_BUSINESS_GROUP_ID'))
431: AND paf.business_group_id = pbg.business_group_id
432: AND
433: ((pts.system_person_type = 'APL'
434: AND NOT EXISTS (SELECT person_id

Line 501: AND ( (nvl(fnd_profile.value(''OTA_ALLOW_FUTURE_ENDDATED_EMP_ENROLLMENTS''),''N'') = ''Y''

497: ,per_business_groups pbg
498: WHERE ppf.person_id = paf.person_id
499: AND (pts.system_person_type IN (''EMP'',''CWK'') OR (paf.assignment_type = ''A'' AND pts.system_person_type =''APL''))
500: AND trunc(sysdate) BETWEEN ppf.effective_start_date AND ppf.effective_end_date
501: AND ( (nvl(fnd_profile.value(''OTA_ALLOW_FUTURE_ENDDATED_EMP_ENROLLMENTS''),''N'') = ''Y''
502: AND trunc(sysdate) BETWEEN paf.effective_start_date and paf.effective_end_date)
503: OR nvl(:3, trunc(sysdate)) between paf.effective_start_date and paf.effective_end_date )
504: AND ( (nvl(fnd_profile.value(''OTA_ALLOW_FUTURE_ENDDATED_EMP_ENROLLMENTS''),''N'') = ''Y''
505: AND trunc(sysdate) BETWEEN ptu.effective_start_date and ptu.effective_end_date)

Line 504: AND ( (nvl(fnd_profile.value(''OTA_ALLOW_FUTURE_ENDDATED_EMP_ENROLLMENTS''),''N'') = ''Y''

500: AND trunc(sysdate) BETWEEN ppf.effective_start_date AND ppf.effective_end_date
501: AND ( (nvl(fnd_profile.value(''OTA_ALLOW_FUTURE_ENDDATED_EMP_ENROLLMENTS''),''N'') = ''Y''
502: AND trunc(sysdate) BETWEEN paf.effective_start_date and paf.effective_end_date)
503: OR nvl(:3, trunc(sysdate)) between paf.effective_start_date and paf.effective_end_date )
504: AND ( (nvl(fnd_profile.value(''OTA_ALLOW_FUTURE_ENDDATED_EMP_ENROLLMENTS''),''N'') = ''Y''
505: AND trunc(sysdate) BETWEEN ptu.effective_start_date and ptu.effective_end_date)
506: OR nvl(:4, trunc(sysdate)) between ptu.effective_start_date and ptu.effective_end_date )
507: AND paf.job_id = pjt.job_id(+)
508: AND pjt.language(+) = USERENV(''LANG'')

Line 518: AND (fnd_profile.value(''OTA_HR_GLOBAL_BUSINESS_GROUP_ID'') IS NOT NULL OR pbg.business_group_id = fnd_profile.value(''PER_BUSINESS_GROUP_ID''))

514: AND paf.organization_id = orgtl.organization_id
515: AND pts.system_person_type IN (''EMP'', ''CWK'', ''APL'')
516: AND paf.assignment_type IN (''A'',''E'',''C'')
517: AND orgtl.language = USERENV(''LANG'')
518: AND (fnd_profile.value(''OTA_HR_GLOBAL_BUSINESS_GROUP_ID'') IS NOT NULL OR pbg.business_group_id = fnd_profile.value(''PER_BUSINESS_GROUP_ID''))
519: AND paf.business_group_id = pbg.business_group_id
520: AND
521: ((pts.system_person_type = ''APL''
522: AND NOT EXISTS (SELECT person_id