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.

[Home] [Help]

APPS.HR_TERMINATION_SS dependencies on FND_PROFILE

Line 3097: SELECT DECODE(fnd_profile.value('HR_LOCAL_OR_GLOBAL_NAME_FORMAT'),'G',ppf.global_name,ppf.local_name) full_name,

3093: cursor cp_get_direct_reports(cp_old_sup_person_id in number
3094: , cp_term_date in varchar2
3095: , cp_flow_identifier in varchar2) is
3096:
3097: SELECT DECODE(fnd_profile.value('HR_LOCAL_OR_GLOBAL_NAME_FORMAT'),'G',ppf.global_name,ppf.local_name) full_name,
3098: paf.object_version_number,
3099: paf.assignment_id,
3100: paf.supervisor_id SupervisorLov_Id,
3101: DECODE(fnd_profile.value('HR_LOCAL_OR_GLOBAL_NAME_FORMAT'),'G',ppf2.global_name,ppf2.local_name) Supervisor_Name,

Line 3101: DECODE(fnd_profile.value('HR_LOCAL_OR_GLOBAL_NAME_FORMAT'),'G',ppf2.global_name,ppf2.local_name) Supervisor_Name,

3097: SELECT DECODE(fnd_profile.value('HR_LOCAL_OR_GLOBAL_NAME_FORMAT'),'G',ppf.global_name,ppf.local_name) full_name,
3098: paf.object_version_number,
3099: paf.assignment_id,
3100: paf.supervisor_id SupervisorLov_Id,
3101: DECODE(fnd_profile.value('HR_LOCAL_OR_GLOBAL_NAME_FORMAT'),'G',ppf2.global_name,ppf2.local_name) Supervisor_Name,
3102: Paf.Person_Id,
3103: (to_date( p_term_date, 'YYYY-MM-DD' ) + 1) Effective_Date,
3104: jbs.name JOB_NAME,
3105: pos.name POSITION_NAME,

Line 3163: AND ( ((NVL(fnd_profile.value('HR_SUPERVISOR_HIERARCHY_USAGE'), 'P') <> 'A')

3159: And to_date(p_term_date, 'YYYY-MM-DD') Between Ppf.Effective_Start_Date And Ppf.Effective_End_Date-1
3160: AND to_date(p_term_date, 'YYYY-MM-DD') BETWEEN ppf2.effective_start_date AND ppf2.effective_end_date
3161: AND ppf2.person_id = paf.supervisor_id
3162: AND paf.supervisor_id = paf2.person_id(+)
3163: AND ( ((NVL(fnd_profile.value('HR_SUPERVISOR_HIERARCHY_USAGE'), 'P') <> 'A')
3164: AND (paf.supervisor_id IS NULL
3165: OR ((paf2.primary_flag = 'Y')
3166: AND (paf2.assignment_type IN ('E','C','A'))) ) )
3167: OR ( (NVL(fnd_profile.value('HR_SUPERVISOR_HIERARCHY_USAGE'), 'P') = 'A')

Line 3167: OR ( (NVL(fnd_profile.value('HR_SUPERVISOR_HIERARCHY_USAGE'), 'P') = 'A')

3163: AND ( ((NVL(fnd_profile.value('HR_SUPERVISOR_HIERARCHY_USAGE'), 'P') <> 'A')
3164: AND (paf.supervisor_id IS NULL
3165: OR ((paf2.primary_flag = 'Y')
3166: AND (paf2.assignment_type IN ('E','C','A'))) ) )
3167: OR ( (NVL(fnd_profile.value('HR_SUPERVISOR_HIERARCHY_USAGE'), 'P') = 'A')
3168: AND (paf.supervisor_id IS NULL
3169: Or Paf.Supervisor_Assignment_Id = Paf2.Assignment_Id) ) )
3170: AND ( to_date(p_term_date, 'YYYY-MM-DD') BETWEEN paf2.effective_start_date(+) AND paf2.effective_end_date(+))
3171: AND paf2.job_id = jbs2.job_id (+)

Line 3262: allowMultipleAsg := fnd_profile.value('HR_ALLOW_MULTIPLE_ASSIGNMENTS');

3258:
3259: if ( l_assignment_security_profile = 'true' ) then
3260:
3261: --
3262: allowMultipleAsg := fnd_profile.value('HR_ALLOW_MULTIPLE_ASSIGNMENTS');
3263: xBgProfileValue := fnd_profile.value('HR_CROSS_BUSINESS_GROUP');
3264:
3265: hr_utility.trace('allowMultipleAsg = ' || allowMultipleAsg);
3266: hr_utility.trace('xBgProfileValue = ' || xBgProfileValue);

Line 3263: xBgProfileValue := fnd_profile.value('HR_CROSS_BUSINESS_GROUP');

3259: if ( l_assignment_security_profile = 'true' ) then
3260:
3261: --
3262: allowMultipleAsg := fnd_profile.value('HR_ALLOW_MULTIPLE_ASSIGNMENTS');
3263: xBgProfileValue := fnd_profile.value('HR_CROSS_BUSINESS_GROUP');
3264:
3265: hr_utility.trace('allowMultipleAsg = ' || allowMultipleAsg);
3266: hr_utility.trace('xBgProfileValue = ' || xBgProfileValue);
3267: