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 PER_ASSIGNMENTS_F

Line 409: , per_assignments_f paf

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
413: ||' AND hasa.assignment_id = paf.assignment_id

Line 419: , per_assignments_f paf

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
423: ||' AND hasa.assignment_id = paf.assignment_id

Line 730: l_assg_id per_assignments_f.assignment_id%TYPE;

726: stperson in number,
727: endperson in number,
728: chunk in number)
729: IS
730: l_assg_id per_assignments_f.assignment_id%TYPE;
731: l_person_id Number;
732: l_assignment_number per_all_assignments_f.assignment_number%type;
733: l_period_of_service_id per_all_assignments_f.period_of_service_id%type;
734:

Line 2425: , per_assignments_f paf

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
2429: AND hasa.assignment_id = paf.assignment_id

Line 2434: , per_assignments_f paf

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
2438: AND hasa.assignment_id = paf.assignment_id

Line 2534: , per_assignments_f paf

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
2538: AND hasa.assignment_id = paf.assignment_id

Line 2543: , per_assignments_f paf

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
2547: AND hasa.assignment_id = paf.assignment_id

Line 2641: , per_assignments_f paf

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
2645: AND hasa.assignment_id = paf.assignment_id

Line 2650: , per_assignments_f paf

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
2654: AND hasa.assignment_id = paf.assignment_id

Line 2784: , per_assignments_f paf

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
2788: AND hasa.assignment_id = paf.assignment_id

Line 2793: , per_assignments_f paf

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
2797: AND hasa.assignment_id = paf.assignment_id