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

Line 770: hr_assignment_Set_amendments hasa

766: ELSIF template_rec.array_sel_criteria(i) = 'AST' THEN
767:
768: insert into psp_selection_cardinality_gt(lookup_code, total_count) (
769: select 'AST', count(distinct paf.person_id) from per_all_assignments_f paf, hr_assignment_sets has ,
770: hr_assignment_Set_amendments hasa
771: where
772: has.assignment_set_id in (
773: select TO_NUMBER(criteria_value1) from psp_report_template_details_h
774: prtd where

Line 792: and not exists (select assignment_id from hr_assignment_Set_amendments hasa where

788: paf.effective_start_date <= p_effort_end and
789: paf.effective_end_date >= p_effort_start
790: AND paf.assignment_type = 'E'
791: and hasa.assignment_Set_id=has.assignment_Set_id and include_or_exclude ='I') )
792: and not exists (select assignment_id from hr_assignment_Set_amendments hasa where
793: hasa.assignment_id = paf.assignment_id and hasa.include_or_exclude ='E'
794: AND paf.assignment_type = 'E'
795: and paf.effective_start_date <= p_effort_end and
796: paf.effective_end_date >= p_effort_start

Line 1499: hr_assignment_set_amendments hasa,

1495: INSERT INTO psp_selected_persons_t (request_id, person_id, assignment_id)
1496: SELECT DISTINCT p_request_id, paf.person_id, paf.assignment_id
1497: FROM per_all_assignments_f paf,
1498: hr_assignment_sets has,
1499: hr_assignment_set_amendments hasa,
1500: per_all_people_f ppf,
1501: per_assignment_status_types past
1502: WHERE has.assignment_set_id IN (SELECT TO_NUMBER(criteria_value1)
1503: FROM psp_report_template_details_h prtd

Line 1519: FROM hr_assignment_set_amendments hasa

1515: AND paf.effective_start_date <= p_effort_end
1516: AND paf.effective_end_date >= p_effort_start
1517: AND hasa.assignment_set_id=has.assignment_set_id AND include_or_exclude ='I'))
1518: AND NOT EXISTS (SELECT assignment_id
1519: FROM hr_assignment_set_amendments hasa
1520: WHERE hasa.assignment_id = paf.assignment_id AND hasa.include_or_exclude ='E'
1521: AND paf.assignment_type = 'E'
1522: AND paf.effective_start_date <= p_effort_end
1523: AND paf.effective_end_date >= p_effort_start)

Line 2345: hr_assignment_set_amendments hasa,

2341: WHERE request_id = p_request_id
2342: AND person_id NOT IN (SELECT NVL(paf.person_id,0)
2343: FROM per_all_assignments_f paf,
2344: hr_assignment_sets has,
2345: hr_assignment_set_amendments hasa,
2346: per_assignment_status_types past
2347: WHERE has.assignment_set_id IN (SELECT TO_NUMBER(criteria_value1)
2348: FROM psp_report_template_details_h prtd
2349: WHERE criteria_lookup_type='PSP_SELECTION_CRITERIA'

Line 2365: FROM hr_assignment_set_amendments hasa

2361: AND paf.effective_end_date >= p_effort_start
2362: AND hasa.assignment_set_id=has.assignment_set_id
2363: AND include_or_exclude ='I'))
2364: AND NOT EXISTS (SELECT assignment_id
2365: FROM hr_assignment_set_amendments hasa
2366: WHERE hasa.assignment_id = paf.assignment_id
2367: AND paf.assignment_type = 'E'
2368: AND hasa.include_or_exclude ='E'
2369: AND paf.effective_start_date <= p_effort_end

Line 3227: hr_assignment_set_amendments hasa,

3223: WHERE request_id = p_request_id
3224: AND person_id IN (SELECT NVL(paf.person_id,0)
3225: FROM per_all_assignments_f paf,
3226: hr_assignment_sets has,
3227: hr_assignment_set_amendments hasa,
3228: per_assignment_status_types past
3229: WHERE has.assignment_set_id IN (SELECT TO_NUMBER(criteria_value1)
3230: FROM psp_report_template_details_h prtd
3231: WHERE criteria_lookup_type='PSP_SELECTION_CRITERIA'

Line 3247: FROM hr_assignment_set_amendments hasa

3243: AND paf.effective_end_date >= p_effort_start
3244: AND hasa.assignment_set_id=has.assignment_set_id
3245: AND include_or_exclude ='I'))
3246: AND NOT EXISTS (SELECT assignment_id
3247: FROM hr_assignment_set_amendments hasa
3248: WHERE hasa.assignment_id = paf.assignment_id
3249: AND paf.assignment_type = 'E'
3250: AND hasa.include_or_exclude ='E'
3251: AND paf.effective_start_date <= p_effort_end

Line 3964: hr_assignment_set_amendments hasa

3960: (lookup_code, total_count)
3961: SELECT 'AST', COUNT(DISTINCT paf.assignment_id)
3962: FROM per_all_assignments_f paf,
3963: hr_assignment_sets has ,
3964: hr_assignment_set_amendments hasa
3965: WHERE has.assignment_set_id IN (SELECT TO_NUMBER(criteria_value1)
3966: FROM psp_report_template_details_h prtd
3967: WHERE criteria_lookup_type='PSP_SELECTION_CRITERIA'
3968: AND criteria_lookup_code='AST'

Line 3983: FROM hr_assignment_set_amendments hasa

3979: AND paf.effective_end_date >= p_effort_start
3980: AND hasa.assignment_set_id=has.assignment_set_id
3981: AND include_or_exclude ='I'))
3982: AND NOT EXISTS (SELECT assignment_id
3983: FROM hr_assignment_set_amendments hasa
3984: WHERE hasa.assignment_id = paf.assignment_id
3985: AND hasa.include_or_exclude ='E'
3986: AND paf.assignment_type = 'E'
3987: AND paf.effective_start_date <= p_effort_end

Line 4557: hr_assignment_set_amendments hasa,

4553: INSERT INTO psp_selected_persons_t (request_id, person_id, assignment_id)
4554: SELECT DISTINCT p_request_id, person_id, paf.assignment_id
4555: FROM per_all_assignments_f paf,
4556: hr_assignment_sets has,
4557: hr_assignment_set_amendments hasa,
4558: per_assignment_status_types past
4559: WHERE has.assignment_set_id IN (SELECT TO_NUMBER(criteria_value1)
4560: FROM psp_report_template_details_h prtd
4561: WHERE criteria_lookup_type='PSP_SELECTION_CRITERIA'

Line 4576: FROM hr_assignment_set_amendments hasa

4572: AND paf.effective_start_date <= p_effort_end
4573: AND paf.effective_end_date >= p_effort_start
4574: AND hasa.assignment_set_id=has.assignment_set_id AND include_or_exclude ='I'))
4575: AND NOT EXISTS (SELECT assignment_id
4576: FROM hr_assignment_set_amendments hasa
4577: WHERE hasa.assignment_id = paf.assignment_id AND hasa.include_or_exclude ='E'
4578: AND paf.assignment_type = 'E'
4579: AND paf.effective_start_date <= p_effort_end
4580: AND paf.effective_end_date >= p_effort_start)

Line 5170: hr_assignment_set_amendments hasa

5166: WHERE request_id = p_request_id
5167: AND assignment_id NOT IN (SELECT NVL(paf.assignment_id,0)
5168: FROM per_all_assignments_f paf,
5169: hr_assignment_sets has,
5170: hr_assignment_set_amendments hasa
5171: WHERE has.assignment_set_id IN (SELECT TO_NUMBER(criteria_value1)
5172: FROM psp_report_template_details_h prtd
5173: WHERE criteria_lookup_type='PSP_SELECTION_CRITERIA'
5174: AND criteria_lookup_code='AST'

Line 5189: FROM hr_assignment_set_amendments hasa

5185: AND paf.effective_end_date >= p_effort_start
5186: AND hasa.assignment_set_id=has.assignment_set_id
5187: AND include_or_exclude ='I'))
5188: AND NOT EXISTS (SELECT assignment_id
5189: FROM hr_assignment_set_amendments hasa
5190: WHERE hasa.assignment_id = paf.assignment_id
5191: AND paf.assignment_type = 'E'
5192: AND hasa.include_or_exclude ='E'
5193: AND paf.effective_start_date <= p_effort_end

Line 5690: hr_assignment_set_amendments hasa

5686: DELETE FROM psp_selected_persons_t
5687: WHERE request_id = p_request_id
5688: AND assignment_id IN (SELECT NVL(paf.assignment_id,0)
5689: FROM per_all_assignments_f paf, hr_assignment_sets has,
5690: hr_assignment_set_amendments hasa
5691: WHERE has.assignment_set_id IN (SELECT TO_NUMBER(criteria_value1)
5692: FROM psp_report_template_details_h prtd
5693: WHERE criteria_lookup_type='PSP_SELECTION_CRITERIA'
5694: AND criteria_lookup_code='AST'

Line 5709: FROM hr_assignment_set_amendments hasa

5705: AND paf.effective_end_date >= p_effort_start
5706: AND hasa.assignment_set_id=has.assignment_set_id
5707: AND include_or_exclude ='I'))
5708: AND NOT EXISTS (SELECT assignment_id
5709: FROM hr_assignment_set_amendments hasa
5710: WHERE hasa.assignment_id = paf.assignment_id
5711: AND paf.assignment_type = 'E'
5712: AND hasa.include_or_exclude ='E'
5713: AND paf.effective_start_date <= p_effort_end