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_SETS

Line 294: hr_assignment_sets has

290: IS
291: SELECT DISTINCT hasa.include_or_exclude inc_or_exc
292: FROM
293: hr_assignment_set_amendments hasa,
294: hr_assignment_sets has
295: WHERE hasa.assignment_set_id = has.assignment_set_id
296: AND has.business_group_id = p_business_Group_id
297: AND has.assignment_set_id = p_assignment_set_id;
298:

Line 408: , hr_assignment_sets has

404: IF p_assignment_set_id IS NOT NULL THEN
405: IF l_cur_inc_exc_flag_rec.inc_or_exc = 'I' THEN
406: g_where_clause_asg_set := ' AND EXISTS(SELECT 1
407: FROM hr_assignment_set_amendments hasa
408: , hr_assignment_sets has
409: , per_assignments_f paf
410: WHERE has.assignment_set_id = hasa.assignment_set_id
411: AND has.business_group_id = paaf.business_group_id
412: AND has.assignment_set_id = '|| p_assignment_set_id

Line 418: , hr_assignment_sets has

414: AND paf.person_id = ppf.person_id) ';
415: ELSIF l_cur_inc_exc_flag_rec.inc_or_exc = 'E' THEN
416: g_where_clause_asg_set := ' AND NOT EXISTS(SELECT 1
417: FROM hr_assignment_set_amendments hasa
418: , hr_assignment_sets has
419: , per_assignments_f paf
420: WHERE has.assignment_set_id = hasa.assignment_set_id
421: AND has.business_group_id = paaf.business_group_id
422: AND has.assignment_set_id = '|| p_assignment_set_id

Line 2424: , hr_assignment_sets has

2420: --
2421: AND ((g_assignment_set_id is not null
2422: AND (g_exc_inc ='I' AND EXISTS(SELECT 1
2423: FROM hr_assignment_set_amendments hasa
2424: , hr_assignment_sets has
2425: , per_assignments_f paf
2426: WHERE has.assignment_set_id = hasa.assignment_set_id
2427: AND has.business_group_id = g_business_group_id
2428: AND has.assignment_set_id = g_assignment_set_id

Line 2433: , hr_assignment_sets has

2429: AND hasa.assignment_id = paf.assignment_id
2430: AND paf.person_id = paaf.person_id)
2431: OR g_exc_inc = 'E' AND NOT EXISTS(SELECT 1
2432: FROM hr_assignment_set_amendments hasa
2433: , hr_assignment_sets has
2434: , per_assignments_f paf
2435: WHERE has.assignment_set_id = hasa.assignment_set_id
2436: AND has.business_group_id = g_business_group_id
2437: AND has.assignment_set_id = g_assignment_set_id

Line 2533: , hr_assignment_sets has

2529: --
2530: AND ((g_assignment_set_id is not null
2531: AND (g_exc_inc ='I' AND EXISTS(SELECT 1
2532: FROM hr_assignment_set_amendments hasa
2533: , hr_assignment_sets has
2534: , per_assignments_f paf
2535: WHERE has.assignment_set_id = hasa.assignment_set_id
2536: AND has.business_group_id = g_business_group_id
2537: AND has.assignment_set_id = g_assignment_set_id

Line 2542: , hr_assignment_sets has

2538: AND hasa.assignment_id = paf.assignment_id
2539: AND paf.person_id = paaf.person_id)
2540: OR g_exc_inc = 'E' AND NOT EXISTS(SELECT 1
2541: FROM hr_assignment_set_amendments hasa
2542: , hr_assignment_sets has
2543: , per_assignments_f paf
2544: WHERE has.assignment_set_id = hasa.assignment_set_id
2545: AND has.business_group_id = g_business_group_id
2546: AND has.assignment_set_id = g_assignment_set_id

Line 2640: , hr_assignment_sets has

2636: --
2637: AND ((g_assignment_set_id is not null
2638: AND (g_exc_inc ='I' AND EXISTS(SELECT 1
2639: FROM hr_assignment_set_amendments hasa
2640: , hr_assignment_sets has
2641: , per_assignments_f paf
2642: WHERE has.assignment_set_id = hasa.assignment_set_id
2643: AND has.business_group_id = g_business_group_id
2644: AND has.assignment_set_id = g_assignment_set_id

Line 2649: , hr_assignment_sets has

2645: AND hasa.assignment_id = paf.assignment_id
2646: AND paf.person_id = paaf.person_id)
2647: OR g_exc_inc = 'E' AND NOT EXISTS(SELECT 1
2648: FROM hr_assignment_set_amendments hasa
2649: , hr_assignment_sets has
2650: , per_assignments_f paf
2651: WHERE has.assignment_set_id = hasa.assignment_set_id
2652: AND has.business_group_id = g_business_group_id
2653: AND has.assignment_set_id = g_assignment_set_id

Line 2783: , hr_assignment_sets has

2779: --
2780: AND ((g_assignment_set_id is not null
2781: AND (g_exc_inc ='I' AND EXISTS(SELECT 1
2782: FROM hr_assignment_set_amendments hasa
2783: , hr_assignment_sets has
2784: , per_assignments_f paf
2785: WHERE has.assignment_set_id = hasa.assignment_set_id
2786: AND has.business_group_id = g_business_group_id
2787: AND has.assignment_set_id = g_assignment_set_id

Line 2792: , hr_assignment_sets has

2788: AND hasa.assignment_id = paf.assignment_id
2789: AND paf.person_id = paaf.person_id)
2790: OR g_exc_inc = 'E' AND NOT EXISTS(SELECT 1
2791: FROM hr_assignment_set_amendments hasa
2792: , hr_assignment_sets has
2793: , per_assignments_f paf
2794: WHERE has.assignment_set_id = hasa.assignment_set_id
2795: AND has.business_group_id = g_business_group_id
2796: AND has.assignment_set_id = g_assignment_set_id