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_PEOPLE_F

Line 491: select 'EMP', count(distinct ppf.person_id) from per_all_people_f ppf, per_assignments_f paf where

487:
488: ELSIF template_rec.array_sel_criteria(i) ='EMP' THEN
489:
490: insert into psp_selection_cardinality_gt(lookup_code, total_count) (
491: select 'EMP', count(distinct ppf.person_id) from per_all_people_f ppf, per_assignments_f paf where
492: ppf.person_id in (select TO_NUMBER(criteria_value1) from psp_report_template_details_h prtd where
493: prtd.criteria_lookup_type='PSP_SELECTION_CRITERIA' and criteria_lookup_code='EMP' and
494: include_exclude_flag='I'
495: and request_id = p_request_id )

Line 1095: FROM per_all_people_f ppf,

1091: ELSIF g_lookup_code ='EMP' then
1092:
1093: INSERT INTO psp_selected_persons_t (request_id, person_id, assignment_id)
1094: SELECT DISTINCT p_request_id, paf.person_id, paf.assignment_id
1095: FROM per_all_people_f ppf,
1096: per_assignments_f paf,
1097: per_assignment_status_types past
1098: WHERE ppf.person_id IN (SELECT TO_NUMBER(criteria_value1)
1099: FROM psp_report_template_details_h prtd

Line 1132: FROM per_all_people_f ppf,

1128: ELSIF g_lookup_code ='SUP' then
1129:
1130: INSERT INTO psp_selected_persons_t (request_id, person_id, assignment_id)
1131: SELECT DISTINCT p_request_id, paf.person_id, paf.assignment_id
1132: FROM per_all_people_f ppf,
1133: per_assignments_f paf,
1134: per_assignment_status_types past
1135: WHERE supervisor_id IN (SELECT TO_NUMBER(criteria_value1)
1136: FROM psp_report_template_details_h prtd

Line 1345: FROM per_all_people_f ppf,

1341: ELSIF g_lookup_code ='PAY' then
1342:
1343: INSERT INTO psp_selected_persons_t (request_id, person_id, assignment_id)
1344: SELECT DISTINCT p_request_id, paf.person_id, paf.assignment_id
1345: FROM per_all_people_f ppf,
1346: per_assignments_f paf,
1347: per_assignment_status_types past
1348: WHERE payroll_id IN (SELECT TO_NUMBER(criteria_value1)
1349: FROM psp_report_template_details_h prtd

Line 1382: FROM per_all_people_f ppf,

1378: ELSIF g_lookup_code ='LOC' then
1379:
1380: INSERT INTO psp_selected_persons_t (request_id, person_id, assignment_id)
1381: SELECT DISTINCT p_request_id, paf.person_id, paf.assignment_id
1382: FROM per_all_people_f ppf,
1383: per_assignments_f paf,
1384: per_assignment_status_types past
1385: WHERE location_id IN (SELECT TO_NUMBER(criteria_value1)
1386: FROM psp_report_template_details_h prtd

Line 1419: FROM per_all_people_f ppf,

1415: ELSIF g_lookup_code ='ORG' then
1416:
1417: INSERT INTO psp_selected_persons_t (request_id, person_id, assignment_id)
1418: SELECT DISTINCT p_request_id, paf.person_id, paf.assignment_id
1419: FROM per_all_people_f ppf,
1420: per_assignments_f paf,
1421: per_assignment_status_types past
1422: WHERE organization_id IN (SELECT TO_NUMBER(criteria_value1)
1423: FROM psp_report_template_details_h prtd

Line 1457: per_all_people_f ppf,

1453:
1454: INSERT INTO psp_selected_persons_t (request_id, person_id, assignment_id)
1455: SELECT DISTINCT p_request_id, paf.person_id, paf.assignment_id
1456: FROM pay_payrolls_f pp,
1457: per_all_people_f ppf,
1458: per_assignments_f paf,
1459: per_assignment_status_types past
1460: WHERE pp.payroll_id = paf.payroll_id
1461: AND pp.consolidation_set_id IN (SELECT TO_NUMBER(criteria_value1)

Line 1500: per_all_people_f ppf,

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
1504: WHERE criteria_lookup_type='PSP_SELECTION_CRITERIA'

Line 1550: FROM per_all_people_f ppf,

1546: ELSIF g_lookup_code ='JOB' then
1547:
1548: INSERT INTO psp_selected_persons_t (request_id, person_id, assignment_id)
1549: SELECT DISTINCT p_request_id, paf.person_id, paf.assignment_id
1550: FROM per_all_people_f ppf,
1551: per_assignments_f paf,
1552: per_assignment_status_types past
1553: WHERE job_id IN (SELECT TO_NUMBER(criteria_value1)
1554: FROM psp_report_template_details_h prtd

Line 1587: FROM per_all_people_f ppf,

1583: ELSIF g_lookup_code ='POS' then
1584:
1585: INSERT INTO psp_selected_persons_t (request_id, person_id, assignment_id)
1586: SELECT DISTINCT p_request_id, paf.person_id, paf.assignment_id
1587: FROM per_all_people_f ppf,
1588: per_assignments_f paf,
1589: per_assignment_status_types past
1590: WHERE position_id IN (SELECT TO_NUMBER(criteria_value1)
1591: FROM psp_report_template_details_h prtd

Line 1624: FROM per_all_people_f ppf,

1620: ELSIF g_lookup_code ='ASS' then
1621:
1622: INSERT INTO psp_selected_persons_t (request_id, person_id, assignment_id)
1623: SELECT DISTINCT p_request_id, paf.person_id, paf.assignment_id
1624: FROM per_all_people_f ppf,
1625: per_assignments_f paf,
1626: per_assignment_status_types past
1627: WHERE paf.assignment_status_type_id IN (SELECT TO_NUMBER(criteria_value1)
1628: FROM psp_report_template_details_h prtd

Line 1696: per_all_people_f ppf,

1692: (request_id, person_id, assignment_id)
1693: (select :request_id , paf.person_id, paf.assignment_id
1694: from per_assignments_f paf,
1695: pay_people_groups ppg,
1696: per_all_people_f ppf,
1697: per_assignment_status_types past
1698: where paf.people_group_id= ppg.people_group_id
1699: AND paf.person_id = ppf.person_id
1700: AND paf.assignment_status_type_id = past.assignment_status_type_id

Line 1926: FROM per_all_people_f ppf,

1922: WHERE request_id = p_request_id
1923: /* Bug 5087294 : Performance fix replacing not in with not exists */
1924: -- AND person_id NOT IN (SELECT NVL(person_id,0)
1925: AND NOT EXISTS ( SELECT 1
1926: FROM per_all_people_f ppf,
1927: per_assignments_f paf,
1928: per_assignment_status_types past
1929: WHERE ppf.person_id IN (SELECT TO_NUMBER(criteria_value1)
1930: FROM psp_report_template_details_h prtd

Line 2714: FROM per_all_people_f ppf,

2710:
2711: DELETE FROM psp_selected_persons_t
2712: WHERE request_id = p_request_id
2713: AND person_id IN (SELECT DISTINCT ppf.person_id
2714: FROM per_all_people_f ppf,
2715: per_assignments_f paf,
2716: per_assignment_status_types past
2717: WHERE ppf.person_id IN (SELECT TO_NUMBER(criteria_value1)
2718: FROM psp_report_template_details_h prtd

Line 4171: FROM per_all_people_f ppf,

4167:
4168: ELSIF g_lookup_code ='EMP' THEN
4169: INSERT INTO psp_selected_persons_t (request_id, person_id, assignment_id)
4170: SELECT DISTINCT p_request_id, paf.person_id, paf.assignment_id
4171: FROM per_all_people_f ppf,
4172: per_assignments_f paf,
4173: per_assignment_status_types past
4174: WHERE ppf.person_id IN (SELECT TO_NUMBER(criteria_value1)
4175: FROM psp_report_template_details_h prtd

Line 4859: FROM per_all_people_f ppf, per_assignments_f paf

4855: WHERE request_id = p_request_id
4856: /* Bug 5087294 : Performance fix replacing not in with not exists */
4857: -- AND person_id NOT IN (SELECT NVL(person_id,0)
4858: AND NOT EXISTS ( SELECT 1
4859: FROM per_all_people_f ppf, per_assignments_f paf
4860: WHERE ppf.person_id IN (SELECT TO_NUMBER(criteria_value1)
4861: FROM psp_report_template_details_h prtd
4862: WHERE prtd.criteria_lookup_type='PSP_SELECTION_CRITERIA'
4863: AND criteria_lookup_code='EMP'

Line 5369: FROM per_all_people_f ppf, per_assignments_f paf

5365: ELSIF template_sel_criteria.array_sel_criteria(i) = 'EMP' THEN
5366: DELETE FROM psp_selected_persons_t
5367: WHERE request_id = p_request_id
5368: AND person_id IN (SELECT DISTINCT ppf.person_id
5369: FROM per_all_people_f ppf, per_assignments_f paf
5370: WHERE ppf.person_id IN (SELECT TO_NUMBER(criteria_value1)
5371: FROM psp_report_template_details_h prtd
5372: WHERE prtd.criteria_lookup_type='PSP_SELECTION_CRITERIA'
5373: AND criteria_lookup_code='EMP'