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 450: , per_assignments_f paf

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
453: AND has.assignment_set_id = '|| p_assignment_set_id
454: ||' AND hasa.assignment_id = paf.assignment_id

Line 460: , per_assignments_f paf

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
463: AND has.assignment_set_id = '|| p_assignment_set_id
464: ||' AND hasa.assignment_id = paf.assignment_id

Line 904: l_assg_id per_assignments_f.assignment_id%TYPE;

900: stperson in number,
901: endperson in number,
902: chunk in number)
903: IS
904: l_assg_id per_assignments_f.assignment_id%TYPE;
905: l_person_id Number;
906: l_assignment_number per_all_assignments_f.assignment_number%type;
907: l_period_of_service_id per_all_assignments_f.period_of_service_id%type;
908:

Line 2708: , per_assignments_f paf

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
2711: AND has.assignment_set_id = g_assignment_set_id
2712: AND hasa.assignment_id = paf.assignment_id

Line 2717: , per_assignments_f paf

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
2720: AND has.assignment_set_id = g_assignment_set_id
2721: AND hasa.assignment_id = paf.assignment_id

Line 2819: , per_assignments_f paf

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
2822: AND has.assignment_set_id = g_assignment_set_id
2823: AND hasa.assignment_id = paf.assignment_id

Line 2828: , per_assignments_f paf

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
2831: AND has.assignment_set_id = g_assignment_set_id
2832: AND hasa.assignment_id = paf.assignment_id

Line 2928: , per_assignments_f paf

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
2931: AND has.assignment_set_id = g_assignment_set_id
2932: AND hasa.assignment_id = paf.assignment_id

Line 2937: , per_assignments_f paf

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
2940: AND has.assignment_set_id = g_assignment_set_id
2941: AND hasa.assignment_id = paf.assignment_id

Line 3071: , per_assignments_f paf

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
3074: AND has.assignment_set_id = g_assignment_set_id
3075: AND hasa.assignment_id = paf.assignment_id

Line 3080: , per_assignments_f paf

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
3083: AND has.assignment_set_id = g_assignment_set_id
3084: AND hasa.assignment_id = paf.assignment_id