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.HXC_PREFERENCE_EVALUATION dependencies on PER_ALL_ASSIGNMENTS_F

Line 145: per_all_assignments_f pa

141: p_evaluation_date IN DATE) IS
142:
143: SELECT hrr.pref_hierarchy_id, hrr.rule_evaluation_order
144: FROM hxc_resource_rules hrr,
145: per_all_assignments_f pa
146: WHERE pa.person_id = p_resource_id
147: AND nvl(hrr.business_group_id,pa.business_group_id) = pa.business_group_id
148: AND pa.primary_flag = 'Y'
149: and pa.assignment_type in ('E','C')

Line 181: per_all_assignments_f pa

177: p_evaluation_date IN DATE) IS
178: SELECT /*+ USE_NL(PA HRR) */
179: hrr.pref_hierarchy_id, hrr.rule_evaluation_order
180: FROM hxc_resource_rules hrr,
181: per_all_assignments_f pa
182: WHERE pa.person_id = p_resource_id
183: AND nvl(hrr.business_group_id,pa.business_group_id) = pa.business_group_id
184: AND pa.primary_flag = 'Y'
185: and pa.assignment_type in ('E','C')

Line 217: per_all_assignments_f pa

213: CURSOR c_eligible_hierarchies_flex(p_resource_id IN NUMBER,
214: p_evaluation_date IN DATE) IS
215: SELECT hrr.pref_hierarchy_id, hrr.rule_evaluation_order
216: FROM hxc_resource_rules hrr,
217: per_all_assignments_f pa
218: WHERE pa.person_id = p_resource_id
219: AND nvl(hrr.business_group_id,pa.business_group_id) = pa.business_group_id
220: AND pa.primary_flag = 'Y'
221: and pa.assignment_type in ('E','C')

Line 1479: per_all_assignments_f pa

1475: decode(hrr.eligibility_criteria_type,
1476: 'ALL_PEOPLE', hr_general.end_of_time
1477: , pa.effective_END_date) elig_end_date
1478: FROM hxc_resource_rules hrr,
1479: per_all_assignments_f pa
1480: WHERE pa.person_id = p_resource_id
1481: AND nvl(hrr.business_group_id,pa.business_group_id) = pa.business_group_id
1482: AND pa.primary_flag = 'Y'
1483: and pa.assignment_type in ('E','C')

Line 1539: per_all_assignments_f pa

1535: hrr.end_date,
1536: pa.effective_start_date elig_start_date,
1537: pa.effective_END_date elig_end_date
1538: FROM hxc_resource_rules hrr,
1539: per_all_assignments_f pa
1540: WHERE pa.person_id = p_resource_id
1541: AND nvl(hrr.business_group_id,pa.business_group_id) = pa.business_group_id
1542: AND pa.primary_flag = 'Y'
1543: and pa.assignment_type in ('E','C')

Line 1595: per_all_assignments_f pa

1591: hrr.start_date, hrr.end_date,
1592: pa.effective_start_date elig_start_date,
1593: pa.effective_END_date elig_end_date
1594: FROM hxc_resource_rules hrr,
1595: per_all_assignments_f pa
1596: WHERE pa.person_id = p_resource_id
1597: AND nvl(hrr.business_group_id,pa.business_group_id) = pa.business_group_id
1598: AND pa.primary_flag = 'Y'
1599: and pa.assignment_type in ('E','C')

Line 2910: p_effective_date per_all_assignments_f.effective_start_date%TYPE

2906: end if;
2907: END set_migration_mode;
2908: FUNCTION employment_ended (
2909: p_person_id per_all_people_f.person_id%TYPE,
2910: p_effective_date per_all_assignments_f.effective_start_date%TYPE
2911: DEFAULT SYSDATE
2912: )
2913: RETURN BOOLEAN
2914: IS

Line 2920: p_effective_date per_all_assignments_f.effective_start_date%TYPE

2916: l_employment_ended BOOLEAN;
2917:
2918: CURSOR csr_existing_employment (
2919: p_person_id per_all_people_f.person_id%TYPE,
2920: p_effective_date per_all_assignments_f.effective_start_date%TYPE
2921: )
2922: IS
2923: SELECT 1
2924: FROM per_all_assignments_f paaf, per_assignment_status_types past

Line 2924: FROM per_all_assignments_f paaf, per_assignment_status_types past

2920: p_effective_date per_all_assignments_f.effective_start_date%TYPE
2921: )
2922: IS
2923: SELECT 1
2924: FROM per_all_assignments_f paaf, per_assignment_status_types past
2925: WHERE paaf.person_id = p_person_id
2926: AND p_effective_date BETWEEN paaf.effective_start_date
2927: AND paaf.effective_end_date
2928: AND paaf.assignment_type IN ( 'E','C')

Line 2969: p_effective_date per_all_assignments_f.effective_start_date%TYPE

2965: END employment_ended;
2966:
2967: FUNCTION assignment_last_eff_dt (
2968: p_person_id per_all_people_f.person_id%TYPE,
2969: p_effective_date per_all_assignments_f.effective_start_date%TYPE
2970: DEFAULT SYSDATE
2971: )
2972: RETURN per_all_assignments_f.effective_start_date%TYPE
2973: IS

Line 2972: RETURN per_all_assignments_f.effective_start_date%TYPE

2968: p_person_id per_all_people_f.person_id%TYPE,
2969: p_effective_date per_all_assignments_f.effective_start_date%TYPE
2970: DEFAULT SYSDATE
2971: )
2972: RETURN per_all_assignments_f.effective_start_date%TYPE
2973: IS
2974: l_proc VARCHAR2 (72);
2975: l_assignment_last_eff_dt per_all_assignments_f.effective_start_date%TYPE;
2976:

Line 2975: l_assignment_last_eff_dt per_all_assignments_f.effective_start_date%TYPE;

2971: )
2972: RETURN per_all_assignments_f.effective_start_date%TYPE
2973: IS
2974: l_proc VARCHAR2 (72);
2975: l_assignment_last_eff_dt per_all_assignments_f.effective_start_date%TYPE;
2976:
2977: CURSOR csr_assignment_last_eff_dt (
2978: p_person_id per_all_people_f.person_id%TYPE,
2979: p_effective_date per_all_assignments_f.effective_start_date%TYPE

Line 2979: p_effective_date per_all_assignments_f.effective_start_date%TYPE

2975: l_assignment_last_eff_dt per_all_assignments_f.effective_start_date%TYPE;
2976:
2977: CURSOR csr_assignment_last_eff_dt (
2978: p_person_id per_all_people_f.person_id%TYPE,
2979: p_effective_date per_all_assignments_f.effective_start_date%TYPE
2980: )
2981: IS
2982: SELECT MAX (paaf.effective_end_date)
2983: FROM per_all_assignments_f paaf, per_assignment_status_types past

Line 2983: FROM per_all_assignments_f paaf, per_assignment_status_types past

2979: p_effective_date per_all_assignments_f.effective_start_date%TYPE
2980: )
2981: IS
2982: SELECT MAX (paaf.effective_end_date)
2983: FROM per_all_assignments_f paaf, per_assignment_status_types past
2984: WHERE paaf.person_id = p_person_id
2985: AND paaf.effective_end_date <= p_effective_date
2986: AND paaf.assignment_type IN ( 'E', 'C')
2987: AND past.assignment_status_type_id = paaf.assignment_status_type_id

Line 3118: per_all_assignments_f pa

3114: pa.person_id as criteria_id,
3115: hrr.pref_hierarchy_id,
3116: hrr.rule_evaluation_order
3117: FROM hxc_resource_rules hrr,
3118: per_all_assignments_f pa
3119: WHERE pa.person_id '||p_resource_sql||'
3120: AND nvl(hrr.business_group_id,pa.business_group_id) = pa.business_group_id
3121: AND pa.primary_flag =''Y''
3122: AND pa.assignment_type in (''E'',''C'')

Line 3172: per_all_assignments_f pa

3168: OR (
3169: hrr.eligibility_criteria_type = ''ALL_PEOPLE''))'|| 'union '||
3170: ' SELECT pa.person_id as criteria_id,hrr.pref_hierarchy_id, hrr.rule_evaluation_order
3171: FROM hxc_resource_rules hrr,
3172: per_all_assignments_f pa
3173: WHERE pa.person_id '||p_resource_sql||'
3174: AND nvl(hrr.business_group_id,pa.business_group_id) = pa.business_group_id
3175: AND pa.primary_flag = ''Y''
3176: AND pa.assignment_type in (''E'',''C'')