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.PAY_IE_EHECS_REPORT_PKG dependencies on HR_ASSIGNMENT_SET_AMENDMENTS

Line 334: hr_assignment_set_amendments hasa,

330: CURSOR cur_inc_exc_flag
331: IS
332: SELECT DISTINCT hasa.include_or_exclude inc_or_exc
333: FROM
334: hr_assignment_set_amendments hasa,
335: hr_assignment_sets has
336: WHERE hasa.assignment_set_id = has.assignment_set_id
337: AND has.business_group_id = p_business_Group_id
338: AND has.assignment_set_id = p_assignment_set_id;

Line 448: FROM hr_assignment_set_amendments hasa

444:
445: IF p_assignment_set_id IS NOT NULL THEN
446: IF l_cur_inc_exc_flag_rec.inc_or_exc = 'I' THEN
447: g_where_clause_asg_set := ' AND EXISTS(SELECT 1
448: FROM hr_assignment_set_amendments hasa
449: , hr_assignment_sets has
450: , per_assignments_f paf
451: WHERE has.assignment_set_id = hasa.assignment_set_id
452: AND has.business_group_id = paaf.business_group_id

Line 458: FROM hr_assignment_set_amendments hasa

454: ||' AND hasa.assignment_id = paf.assignment_id
455: AND paf.person_id = ppf.person_id) ';
456: ELSIF l_cur_inc_exc_flag_rec.inc_or_exc = 'E' THEN
457: g_where_clause_asg_set := ' AND NOT EXISTS(SELECT 1
458: FROM hr_assignment_set_amendments hasa
459: , hr_assignment_sets has
460: , per_assignments_f paf
461: WHERE has.assignment_set_id = hasa.assignment_set_id
462: AND has.business_group_id = paaf.business_group_id

Line 2706: FROM hr_assignment_set_amendments hasa

2702: and paaf.effective_start_date <= g_qtr_end_date --g_qtr_start_date --bug 7294966
2703: --
2704: AND ((g_assignment_set_id is not null
2705: AND (g_exc_inc ='I' AND EXISTS(SELECT 1
2706: FROM hr_assignment_set_amendments hasa
2707: , hr_assignment_sets has
2708: , per_assignments_f paf
2709: WHERE has.assignment_set_id = hasa.assignment_set_id
2710: AND has.business_group_id = g_business_group_id

Line 2715: FROM hr_assignment_set_amendments hasa

2711: AND has.assignment_set_id = g_assignment_set_id
2712: AND hasa.assignment_id = paf.assignment_id
2713: AND paf.person_id = paaf.person_id)
2714: OR g_exc_inc = 'E' AND NOT EXISTS(SELECT 1
2715: FROM hr_assignment_set_amendments hasa
2716: , hr_assignment_sets has
2717: , per_assignments_f paf
2718: WHERE has.assignment_set_id = hasa.assignment_set_id
2719: AND has.business_group_id = g_business_group_id

Line 2817: FROM hr_assignment_set_amendments hasa

2813: and paaf.effective_start_date <= g_qtr_end_date
2814: --
2815: AND ((g_assignment_set_id is not null
2816: AND (g_exc_inc ='I' AND EXISTS(SELECT 1
2817: FROM hr_assignment_set_amendments hasa
2818: , hr_assignment_sets has
2819: , per_assignments_f paf
2820: WHERE has.assignment_set_id = hasa.assignment_set_id
2821: AND has.business_group_id = g_business_group_id

Line 2826: FROM hr_assignment_set_amendments hasa

2822: AND has.assignment_set_id = g_assignment_set_id
2823: AND hasa.assignment_id = paf.assignment_id
2824: AND paf.person_id = paaf.person_id)
2825: OR g_exc_inc = 'E' AND NOT EXISTS(SELECT 1
2826: FROM hr_assignment_set_amendments hasa
2827: , hr_assignment_sets has
2828: , per_assignments_f paf
2829: WHERE has.assignment_set_id = hasa.assignment_set_id
2830: AND has.business_group_id = g_business_group_id

Line 2926: FROM hr_assignment_set_amendments hasa

2922: and paaf.effective_start_date between pps.date_start and g_qtr_end_date
2923: --
2924: AND ((g_assignment_set_id is not null
2925: AND (g_exc_inc ='I' AND EXISTS(SELECT 1
2926: FROM hr_assignment_set_amendments hasa
2927: , hr_assignment_sets has
2928: , per_assignments_f paf
2929: WHERE has.assignment_set_id = hasa.assignment_set_id
2930: AND has.business_group_id = g_business_group_id

Line 2935: FROM hr_assignment_set_amendments hasa

2931: AND has.assignment_set_id = g_assignment_set_id
2932: AND hasa.assignment_id = paf.assignment_id
2933: AND paf.person_id = paaf.person_id)
2934: OR g_exc_inc = 'E' AND NOT EXISTS(SELECT 1
2935: FROM hr_assignment_set_amendments hasa
2936: , hr_assignment_sets has
2937: , per_assignments_f paf
2938: WHERE has.assignment_set_id = hasa.assignment_set_id
2939: AND has.business_group_id = g_business_group_id

Line 3069: FROM hr_assignment_set_amendments hasa

3065: and paaf.effective_end_date >= g_qtr_start_date
3066: --
3067: AND ((g_assignment_set_id is not null
3068: AND (g_exc_inc ='I' AND EXISTS(SELECT 1
3069: FROM hr_assignment_set_amendments hasa
3070: , hr_assignment_sets has
3071: , per_assignments_f paf
3072: WHERE has.assignment_set_id = hasa.assignment_set_id
3073: AND has.business_group_id = g_business_group_id

Line 3078: FROM hr_assignment_set_amendments hasa

3074: AND has.assignment_set_id = g_assignment_set_id
3075: AND hasa.assignment_id = paf.assignment_id
3076: AND paf.person_id = paaf.person_id)
3077: OR g_exc_inc = 'E' AND NOT EXISTS(SELECT 1
3078: FROM hr_assignment_set_amendments hasa
3079: , hr_assignment_sets has
3080: , per_assignments_f paf
3081: WHERE has.assignment_set_id = hasa.assignment_set_id
3082: AND has.business_group_id = g_business_group_id