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 1813: FROM per_all_people_f ppf,

1809:
1810:
1811: INSERT INTO psp_selected_persons_t (request_id, person_id, assignment_id)
1812: SELECT DISTINCT p_request_id, paf.person_id, paf.assignment_id
1813: FROM per_all_people_f ppf,
1814: per_assignments_f paf,
1815: per_assignment_status_types past
1816: WHERE ppf.person_id IN (select person_id from per_people_f where
1817: business_group_id = p_business_group_id and

Line 1959: FROM per_all_people_f ppf,

1955: WHERE request_id = p_request_id
1956: /* Bug 5087294 : Performance fix replacing not in with not exists */
1957: -- AND person_id NOT IN (SELECT NVL(person_id,0)
1958: AND NOT EXISTS ( SELECT 1
1959: FROM per_all_people_f ppf,
1960: per_assignments_f paf,
1961: per_assignment_status_types past
1962: WHERE ppf.person_id IN (SELECT TO_NUMBER(criteria_value1)
1963: FROM psp_report_template_details_h prtd

Line 2747: FROM per_all_people_f ppf,

2743:
2744: DELETE FROM psp_selected_persons_t
2745: WHERE request_id = p_request_id
2746: AND person_id IN (SELECT DISTINCT ppf.person_id
2747: FROM per_all_people_f ppf,
2748: per_assignments_f paf,
2749: per_assignment_status_types past
2750: WHERE ppf.person_id IN (SELECT TO_NUMBER(criteria_value1)
2751: FROM psp_report_template_details_h prtd

Line 4204: FROM per_all_people_f ppf,

4200:
4201: ELSIF g_lookup_code ='EMP' THEN
4202: INSERT INTO psp_selected_persons_t (request_id, person_id, assignment_id)
4203: SELECT DISTINCT p_request_id, paf.person_id, paf.assignment_id
4204: FROM per_all_people_f ppf,
4205: per_assignments_f paf,
4206: per_assignment_status_types past
4207: WHERE ppf.person_id IN (SELECT TO_NUMBER(criteria_value1)
4208: FROM psp_report_template_details_h prtd

Line 4892: FROM per_all_people_f ppf, per_assignments_f paf

4888: WHERE request_id = p_request_id
4889: /* Bug 5087294 : Performance fix replacing not in with not exists */
4890: -- AND person_id NOT IN (SELECT NVL(person_id,0)
4891: AND NOT EXISTS ( SELECT 1
4892: FROM per_all_people_f ppf, per_assignments_f paf
4893: WHERE ppf.person_id IN (SELECT TO_NUMBER(criteria_value1)
4894: FROM psp_report_template_details_h prtd
4895: WHERE prtd.criteria_lookup_type='PSP_SELECTION_CRITERIA'
4896: AND criteria_lookup_code='EMP'

Line 5402: FROM per_all_people_f ppf, per_assignments_f paf

5398: ELSIF template_sel_criteria.array_sel_criteria(i) = 'EMP' THEN
5399: DELETE FROM psp_selected_persons_t
5400: WHERE request_id = p_request_id
5401: AND person_id IN (SELECT DISTINCT ppf.person_id
5402: FROM per_all_people_f ppf, per_assignments_f paf
5403: WHERE ppf.person_id IN (SELECT TO_NUMBER(criteria_value1)
5404: FROM psp_report_template_details_h prtd
5405: WHERE prtd.criteria_lookup_type='PSP_SELECTION_CRITERIA'
5406: AND criteria_lookup_code='EMP'