APPS.HR_TERMINATION_SS dependencies on HR_GENERAL2

Line 3033: and ((hr_general2.supervisor_assignments_in_use <> 'TRUE') or

3029: and paf2.primary_flag in (cp_param_9 , cp_param_10)
3030: and paf2.assignment_type in ('E','C')
3031: and to_date(cp_param_11, 'YYYY-MM-DD') between paf2.effective_start_date and paf2.effective_end_date
3032: and paf2.person_id = ppf.person_id
3033: and ((hr_general2.supervisor_assignments_in_use <> 'TRUE') or
3034: paf2.supervisor_assignment_id = cp_param_12)
3035: and ((hr_general2.supervisor_assignments_in_use <> 'TRUE') or
3036: paf2.assignment_id = paf.assignment_id)
3037:

Line 3035: and ((hr_general2.supervisor_assignments_in_use <> 'TRUE') or

3031: and to_date(cp_param_11, 'YYYY-MM-DD') between paf2.effective_start_date and paf2.effective_end_date
3032: and paf2.person_id = ppf.person_id
3033: and ((hr_general2.supervisor_assignments_in_use <> 'TRUE') or
3034: paf2.supervisor_assignment_id = cp_param_12)
3035: and ((hr_general2.supervisor_assignments_in_use <> 'TRUE') or
3036: paf2.assignment_id = paf.assignment_id)
3037:
3038:
3039: )

Line 3136: Or ((Hr_General2.Supervisor_Assignments_In_Use = 'TRUE'

3132: hr_all_positions_f_tl pos2 ,
3133: Hr_All_Organization_Units_Tl Org2
3134: Where Paf.Supervisor_Id = p_old_sup_person_id
3135: AND ((p_flow_identifier = 'TERMINATION_FLOW')
3136: Or ((Hr_General2.Supervisor_Assignments_In_Use = 'TRUE'
3137: Or p_flow_identifier = 'TERM_SEC_ASGN_FLOW')
3138: AND paf.supervisor_assignment_id = p_old_sup_asg_id)
3139: Or ((Hr_General2.Supervisor_Assignments_In_Use <> 'TRUE')
3140: AND p_flow_identifier = 'ASSIGNMENT_FLOW'))

Line 3139: Or ((Hr_General2.Supervisor_Assignments_In_Use <> 'TRUE')

3135: AND ((p_flow_identifier = 'TERMINATION_FLOW')
3136: Or ((Hr_General2.Supervisor_Assignments_In_Use = 'TRUE'
3137: Or p_flow_identifier = 'TERM_SEC_ASGN_FLOW')
3138: AND paf.supervisor_assignment_id = p_old_sup_asg_id)
3139: Or ((Hr_General2.Supervisor_Assignments_In_Use <> 'TRUE')
3140: AND p_flow_identifier = 'ASSIGNMENT_FLOW'))
3141: AND paf.person_id = ppf.person_id
3142: AND ((ppf.current_employee_flag = 'Y'
3143: AND paf.assignment_type = 'E')

Line 3246: l_assignment_security_profile := hr_general2.supervisor_assignments_in_use ;

3242: if ( nvl(l_new_sup_asg_id, -1) = -1) then
3243: l_new_sup_asg_id := null;
3244: end if;
3245:
3246: l_assignment_security_profile := hr_general2.supervisor_assignments_in_use ;
3247:
3248: if ( p_validate = 'Y' ) then
3249: savepoint madr_sp;
3250: end if;