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 PER_ALL_ASSIGNMENTS_F

Line 507: select 'SUP', count(distinct person_id) from per_all_assignments_f paf where

503:
504: ELSIF template_rec.array_sel_criteria(i) ='SUP' THEN
505:
506: insert into psp_selection_cardinality_gt(lookup_code, total_count) (
507: select 'SUP', count(distinct person_id) from per_all_assignments_f paf where
508: supervisor_id in (select TO_NUMBER(criteria_value1) from psp_report_template_details_h prtd where
509: criteria_lookup_type='PSP_SELECTION_CRITERIA' and criteria_lookup_code='SUP'
510: and request_id = p_request_id
511: and include_exclude_flag='I'

Line 769: select 'AST', count(distinct paf.person_id) from per_all_assignments_f paf, hr_assignment_sets has ,

765:
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

Line 1497: FROM per_all_assignments_f paf,

1493: ELSIF g_lookup_code = 'AST' then
1494:
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

Line 2001: FROM per_all_assignments_f paf,

1997: WHERE request_id = p_request_id
1998: /* Bug 5087294 : Performance fix replacing not in with not exists */
1999: -- AND assignment_id NOT IN (SELECT NVL(assignment_id,0)
2000: AND NOT EXISTS ( SELECT 1
2001: FROM per_all_assignments_f paf,
2002: psp_report_template_details_h prtd,
2003: per_assignment_status_types past
2004: WHERE criteria_lookup_type='PSP_SELECTION_CRITERIA'
2005: AND criteria_lookup_code='SUP'

Line 2343: FROM per_all_assignments_f paf,

2339:
2340: DELETE FROM psp_selected_persons_t
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)

Line 2786: FROM per_all_assignments_f paf,

2782:
2783: DELETE FROM psp_selected_persons_t
2784: WHERE request_id = p_request_id
2785: AND person_id IN (SELECT NVL(person_id,0)
2786: FROM per_all_assignments_f paf,
2787: psp_report_template_details_h prtd,
2788: per_assignment_status_types past
2789: WHERE criteria_lookup_type='PSP_SELECTION_CRITERIA'
2790: AND criteria_lookup_code='SUP'

Line 3225: FROM per_all_assignments_f paf,

3221:
3222: DELETE FROM psp_selected_persons_t
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)

Line 3682: FROM per_all_assignments_f paf

3678: AND paf.effective_end_date >= p_effort_start;
3679: ELSIF template_rec.array_sel_criteria(i) ='EMP' THEN
3680: INSERT INTO psp_selection_cardinality_gt (lookup_code, total_count)
3681: SELECT 'EMP', COUNT(DISTINCT paf.assignment_id)
3682: FROM per_all_assignments_f paf
3683: WHERE paf.person_id IN (SELECT TO_NUMBER(criteria_value1)
3684: FROM psp_report_template_details_h prtd
3685: WHERE prtd.criteria_lookup_type='PSP_SELECTION_CRITERIA'
3686: AND criteria_lookup_code='EMP'

Line 3696: FROM per_all_assignments_f paf

3692: ELSIF template_rec.array_sel_criteria(i) ='SUP' THEN
3693: INSERT INTO psp_selection_cardinality_gt
3694: (lookup_code, total_count)
3695: SELECT 'SUP', COUNT(DISTINCT assignment_id)
3696: FROM per_all_assignments_f paf
3697: WHERE supervisor_id IN (SELECT TO_NUMBER(criteria_value1)
3698: FROM psp_report_template_details_h prtd
3699: WHERE criteria_lookup_type='PSP_SELECTION_CRITERIA'
3700: AND criteria_lookup_code='SUP'

Line 3962: FROM per_all_assignments_f paf,

3958: ELSIF template_rec.array_sel_criteria(i) = 'AST' THEN
3959: INSERT INTO psp_selection_cardinality_gt
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

Line 4241: FROM per_all_assignments_f paf,

4237:
4238: ELSIF g_lookup_code ='SUP' THEN
4239: INSERT INTO psp_selected_persons_t (request_id, person_id, assignment_id)
4240: SELECT DISTINCT p_request_id, paf.person_id, paf.assignment_id
4241: FROM per_all_assignments_f paf,
4242: per_assignment_status_types past
4243: WHERE supervisor_id IN (SELECT TO_NUMBER(criteria_value1)
4244: FROM psp_report_template_details_h prtd
4245: WHERE criteria_lookup_type='PSP_SELECTION_CRITERIA'

Line 4555: FROM per_all_assignments_f paf,

4551: ELSIF g_lookup_code = 'AST' THEN
4552:
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)

Line 4912: FROM per_all_assignments_f paf,

4908: WHERE request_id = p_request_id
4909: /* Bug 5087294 : Performance fix replacing not in with not exists */
4910: -- AND assignment_id NOT IN (SELECT NVL(assignment_id,0)
4911: AND NOT EXISTS ( SELECT 1
4912: FROM per_all_assignments_f paf,
4913: psp_report_template_details_h prtd
4914: WHERE criteria_lookup_type='PSP_SELECTION_CRITERIA'
4915: AND criteria_lookup_code='SUP'
4916: AND include_exclude_flag='I'

Line 5168: FROM per_all_assignments_f paf,

5164: ELSIF template_sel_criteria.array_sel_criteria(i) = 'AST' THEN
5165: DELETE FROM psp_selected_persons_t
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

Line 5419: FROM per_all_assignments_f paf,

5415: ELSIF template_sel_criteria.array_sel_criteria(i) ='SUP' THEN
5416: DELETE FROM psp_selected_persons_t
5417: WHERE request_id = p_request_id
5418: AND assignment_id IN (SELECT NVL(assignment_id,0)
5419: FROM per_all_assignments_f paf,
5420: psp_report_template_details_h prtd
5421: WHERE criteria_lookup_type='PSP_SELECTION_CRITERIA'
5422: AND criteria_lookup_code='SUP'
5423: AND include_exclude_flag='E'

Line 5689: FROM per_all_assignments_f paf, hr_assignment_sets has,

5685: ELSIF template_sel_criteria.array_sel_criteria(i) = 'AST' THEN
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'