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 1968: FROM per_all_assignments_f paf,

1964: WHERE request_id = p_request_id
1965: /* Bug 5087294 : Performance fix replacing not in with not exists */
1966: -- AND assignment_id NOT IN (SELECT NVL(assignment_id,0)
1967: AND NOT EXISTS ( SELECT 1
1968: FROM per_all_assignments_f paf,
1969: psp_report_template_details_h prtd,
1970: per_assignment_status_types past
1971: WHERE criteria_lookup_type='PSP_SELECTION_CRITERIA'
1972: AND criteria_lookup_code='SUP'

Line 2310: FROM per_all_assignments_f paf,

2306:
2307: DELETE FROM psp_selected_persons_t
2308: WHERE request_id = p_request_id
2309: AND person_id NOT IN (SELECT NVL(paf.person_id,0)
2310: FROM per_all_assignments_f paf,
2311: hr_assignment_sets has,
2312: hr_assignment_set_amendments hasa,
2313: per_assignment_status_types past
2314: WHERE has.assignment_set_id IN (SELECT TO_NUMBER(criteria_value1)

Line 2753: FROM per_all_assignments_f paf,

2749:
2750: DELETE FROM psp_selected_persons_t
2751: WHERE request_id = p_request_id
2752: AND person_id IN (SELECT NVL(person_id,0)
2753: FROM per_all_assignments_f paf,
2754: psp_report_template_details_h prtd,
2755: per_assignment_status_types past
2756: WHERE criteria_lookup_type='PSP_SELECTION_CRITERIA'
2757: AND criteria_lookup_code='SUP'

Line 3192: FROM per_all_assignments_f paf,

3188:
3189: DELETE FROM psp_selected_persons_t
3190: WHERE request_id = p_request_id
3191: AND person_id IN (SELECT NVL(paf.person_id,0)
3192: FROM per_all_assignments_f paf,
3193: hr_assignment_sets has,
3194: hr_assignment_set_amendments hasa,
3195: per_assignment_status_types past
3196: WHERE has.assignment_set_id IN (SELECT TO_NUMBER(criteria_value1)

Line 3649: FROM per_all_assignments_f paf

3645: AND paf.effective_end_date >= p_effort_start;
3646: ELSIF template_rec.array_sel_criteria(i) ='EMP' THEN
3647: INSERT INTO psp_selection_cardinality_gt (lookup_code, total_count)
3648: SELECT 'EMP', COUNT(DISTINCT paf.assignment_id)
3649: FROM per_all_assignments_f paf
3650: WHERE paf.person_id IN (SELECT TO_NUMBER(criteria_value1)
3651: FROM psp_report_template_details_h prtd
3652: WHERE prtd.criteria_lookup_type='PSP_SELECTION_CRITERIA'
3653: AND criteria_lookup_code='EMP'

Line 3663: FROM per_all_assignments_f paf

3659: ELSIF template_rec.array_sel_criteria(i) ='SUP' THEN
3660: INSERT INTO psp_selection_cardinality_gt
3661: (lookup_code, total_count)
3662: SELECT 'SUP', COUNT(DISTINCT assignment_id)
3663: FROM per_all_assignments_f paf
3664: WHERE supervisor_id IN (SELECT TO_NUMBER(criteria_value1)
3665: FROM psp_report_template_details_h prtd
3666: WHERE criteria_lookup_type='PSP_SELECTION_CRITERIA'
3667: AND criteria_lookup_code='SUP'

Line 3929: FROM per_all_assignments_f paf,

3925: ELSIF template_rec.array_sel_criteria(i) = 'AST' THEN
3926: INSERT INTO psp_selection_cardinality_gt
3927: (lookup_code, total_count)
3928: SELECT 'AST', COUNT(DISTINCT paf.assignment_id)
3929: FROM per_all_assignments_f paf,
3930: hr_assignment_sets has ,
3931: hr_assignment_set_amendments hasa
3932: WHERE has.assignment_set_id IN (SELECT TO_NUMBER(criteria_value1)
3933: FROM psp_report_template_details_h prtd

Line 4208: FROM per_all_assignments_f paf,

4204:
4205: ELSIF g_lookup_code ='SUP' THEN
4206: INSERT INTO psp_selected_persons_t (request_id, person_id, assignment_id)
4207: SELECT DISTINCT p_request_id, paf.person_id, paf.assignment_id
4208: FROM per_all_assignments_f paf,
4209: per_assignment_status_types past
4210: WHERE supervisor_id IN (SELECT TO_NUMBER(criteria_value1)
4211: FROM psp_report_template_details_h prtd
4212: WHERE criteria_lookup_type='PSP_SELECTION_CRITERIA'

Line 4522: FROM per_all_assignments_f paf,

4518: ELSIF g_lookup_code = 'AST' THEN
4519:
4520: INSERT INTO psp_selected_persons_t (request_id, person_id, assignment_id)
4521: SELECT DISTINCT p_request_id, person_id, paf.assignment_id
4522: FROM per_all_assignments_f paf,
4523: hr_assignment_sets has,
4524: hr_assignment_set_amendments hasa,
4525: per_assignment_status_types past
4526: WHERE has.assignment_set_id IN (SELECT TO_NUMBER(criteria_value1)

Line 4879: FROM per_all_assignments_f paf,

4875: WHERE request_id = p_request_id
4876: /* Bug 5087294 : Performance fix replacing not in with not exists */
4877: -- AND assignment_id NOT IN (SELECT NVL(assignment_id,0)
4878: AND NOT EXISTS ( SELECT 1
4879: FROM per_all_assignments_f paf,
4880: psp_report_template_details_h prtd
4881: WHERE criteria_lookup_type='PSP_SELECTION_CRITERIA'
4882: AND criteria_lookup_code='SUP'
4883: AND include_exclude_flag='I'

Line 5135: FROM per_all_assignments_f paf,

5131: ELSIF template_sel_criteria.array_sel_criteria(i) = 'AST' THEN
5132: DELETE FROM psp_selected_persons_t
5133: WHERE request_id = p_request_id
5134: AND assignment_id NOT IN (SELECT NVL(paf.assignment_id,0)
5135: FROM per_all_assignments_f paf,
5136: hr_assignment_sets has,
5137: hr_assignment_set_amendments hasa
5138: WHERE has.assignment_set_id IN (SELECT TO_NUMBER(criteria_value1)
5139: FROM psp_report_template_details_h prtd

Line 5386: FROM per_all_assignments_f paf,

5382: ELSIF template_sel_criteria.array_sel_criteria(i) ='SUP' THEN
5383: DELETE FROM psp_selected_persons_t
5384: WHERE request_id = p_request_id
5385: AND assignment_id IN (SELECT NVL(assignment_id,0)
5386: FROM per_all_assignments_f paf,
5387: psp_report_template_details_h prtd
5388: WHERE criteria_lookup_type='PSP_SELECTION_CRITERIA'
5389: AND criteria_lookup_code='SUP'
5390: AND include_exclude_flag='E'

Line 5656: FROM per_all_assignments_f paf, hr_assignment_sets has,

5652: ELSIF template_sel_criteria.array_sel_criteria(i) = 'AST' THEN
5653: DELETE FROM psp_selected_persons_t
5654: WHERE request_id = p_request_id
5655: AND assignment_id IN (SELECT NVL(paf.assignment_id,0)
5656: FROM per_all_assignments_f paf, hr_assignment_sets has,
5657: hr_assignment_set_amendments hasa
5658: WHERE has.assignment_set_id IN (SELECT TO_NUMBER(criteria_value1)
5659: FROM psp_report_template_details_h prtd
5660: WHERE criteria_lookup_type='PSP_SELECTION_CRITERIA'