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_ASSIGNMENT_STATUS_TYPES

Line 1060: per_assignment_status_types past

1056: INSERT INTO psp_selected_persons_t (request_id, person_id, assignment_id)
1057: SELECT DISTINCT p_request_id, paf.person_id, paf.assignment_id
1058: FROM per_people_f ppf,
1059: per_assignments_f paf,
1060: per_assignment_status_types past
1061: WHERE person_type_id IN (SELECT TO_NUMBER(criteria_value1)
1062: FROM psp_report_template_details_h prtd
1063: WHERE prtd.criteria_lookup_type='PSP_SELECTION_CRITERIA'
1064: AND criteria_lookup_code='PTY'

Line 1097: per_assignment_status_types past

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
1100: WHERE prtd.criteria_lookup_type='PSP_SELECTION_CRITERIA'
1101: AND criteria_lookup_code='EMP'

Line 1134: per_assignment_status_types past

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
1137: WHERE criteria_lookup_type='PSP_SELECTION_CRITERIA'
1138: AND criteria_lookup_code='SUP'

Line 1347: per_assignment_status_types past

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
1350: WHERE criteria_lookup_type='PSP_SELECTION_CRITERIA'
1351: AND criteria_lookup_code='PAY'

Line 1384: per_assignment_status_types past

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
1387: WHERE criteria_lookup_type='PSP_SELECTION_CRITERIA'
1388: AND criteria_lookup_code='LOC'

Line 1421: per_assignment_status_types past

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
1424: WHERE criteria_lookup_type='PSP_SELECTION_CRITERIA'
1425: AND criteria_lookup_code='ORG'

Line 1459: per_assignment_status_types past

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)
1462: FROM psp_report_template_details_h prtd
1463: WHERE criteria_lookup_type='PSP_SELECTION_CRITERIA'

Line 1501: per_assignment_status_types past

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'
1505: AND criteria_lookup_code='AST'

Line 1552: per_assignment_status_types past

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
1555: WHERE criteria_lookup_type='PSP_SELECTION_CRITERIA'
1556: AND criteria_lookup_code='JOB'

Line 1589: per_assignment_status_types past

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
1592: WHERE criteria_lookup_type='PSP_SELECTION_CRITERIA'
1593: AND criteria_lookup_code='POS'

Line 1626: per_assignment_status_types past

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
1629: WHERE criteria_lookup_type='PSP_SELECTION_CRITERIA'
1630: AND criteria_lookup_code='ASS'

Line 1697: per_assignment_status_types past

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
1701: AND paf.assignment_type = ''' || 'E' || '''

Line 1815: per_assignment_status_types past

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
1818: effective_start_date <= p_effort_end and
1819: effective_end_date >= p_effort_start)

Line 1921: per_assignment_status_types past

1917: AND NOT EXISTS ( SELECT 1
1918: FROM per_people_f ppf,
1919: psp_report_template_details_h prtd,
1920: per_assignments_f paf,
1921: per_assignment_status_types past
1922: WHERE criteria_lookup_type='PSP_SELECTION_CRITERIA'
1923: AND criteria_lookup_code='PTY'
1924: AND paf.person_id = ppf.person_id
1925: AND paf.assignment_type = 'E'

Line 1961: per_assignment_status_types past

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
1964: WHERE prtd.criteria_lookup_type='PSP_SELECTION_CRITERIA'
1965: AND criteria_lookup_code='EMP'

Line 2003: per_assignment_status_types past

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'
2006: AND include_exclude_flag='I'
2007: AND paf.supervisor_id = TO_NUMBER(prtd.criteria_value1)

Line 2193: per_assignment_status_types past

2189: -- AND assignment_id NOT IN (SELECT NVL(assignment_id,0)
2190: AND NOT EXISTS ( SELECT 1
2191: FROM per_assignments_f paf,
2192: psp_report_template_details_h prtd,
2193: per_assignment_status_types past
2194: WHERE criteria_lookup_type='PSP_SELECTION_CRITERIA'
2195: AND criteria_lookup_code='PAY'
2196: AND include_exclude_flag='I'
2197: AND paf.assignment_type = 'E'

Line 2232: per_assignment_status_types past

2228: -- AND assignment_id NOT IN (SELECT NVL(assignment_id,0)
2229: AND NOT EXISTS ( SELECT 1
2230: FROM per_assignments_f paf ,
2231: psp_report_template_details_h prtd,
2232: per_assignment_status_types past
2233: WHERE criteria_lookup_type='PSP_SELECTION_CRITERIA'
2234: AND criteria_lookup_code='LOC'
2235: AND paf.assignment_type = 'E'
2236: AND effective_start_date <= p_effort_end

Line 2268: per_assignment_status_types past

2264: -- AND assignment_id NOT IN (SELECT NVL(assignment_id,0)
2265: AND NOT EXISTS ( SELECT 1
2266: FROM per_assignments_f paf ,
2267: psp_report_template_details_h prtd,
2268: per_assignment_status_types past
2269: WHERE criteria_lookup_type='PSP_SELECTION_CRITERIA'
2270: AND criteria_lookup_code='ORG'
2271: AND include_exclude_flag='I'
2272: AND paf.assignment_type = 'E'

Line 2305: per_assignment_status_types past

2301: -- AND assignment_id NOT IN (SELECT NVL(assignment_id,0)
2302: AND NOT EXISTS ( SELECT 1
2303: FROM per_assignments_f paf,
2304: pay_payrolls_f ppf,
2305: per_assignment_status_types past
2306: WHERE ppf.payroll_id = paf.payroll_id
2307: AND ppf.consolidation_set_id IN (SELECT TO_NUMBER(criteria_value1)
2308: FROM psp_report_template_details_h prtd
2309: WHERE criteria_lookup_type='PSP_SELECTION_CRITERIA'

Line 2346: per_assignment_status_types past

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'
2350: AND criteria_lookup_code='AST'

Line 2399: per_assignment_status_types past

2395: -- AND assignment_id NOT IN (SELECT NVL(assignment_id,0)
2396: AND NOT EXISTS ( SELECT 1
2397: FROM per_assignments_f paf ,
2398: psp_report_template_details_h prtd,
2399: per_assignment_status_types past
2400: WHERE criteria_lookup_type='PSP_SELECTION_CRITERIA'
2401: AND criteria_lookup_code='JOB'
2402: AND include_exclude_flag='I'
2403: AND paf.assignment_type = 'E'

Line 2436: per_assignment_status_types past

2432: -- AND assignment_id NOT IN (SELECT NVL(assignment_id,0)
2433: AND NOT EXISTS ( SELECT 1
2434: FROM per_assignments_f paf ,
2435: psp_report_template_details_h prtd,
2436: per_assignment_status_types past
2437: WHERE criteria_lookup_type='PSP_SELECTION_CRITERIA'
2438: AND criteria_lookup_code='POS'
2439: AND paf.assignment_type = 'E'
2440: and

Line 2475: per_assignment_status_types past

2471: -- AND assignment_id NOT IN (SELECT NVL(assignment_id,0)
2472: AND NOT EXISTS ( SELECT 1
2473: FROM per_assignments_f paf ,
2474: psp_report_template_details_h prtd,
2475: per_assignment_status_types past
2476: WHERE criteria_lookup_type='PSP_SELECTION_CRITERIA'
2477: AND criteria_lookup_code='ASS'
2478: AND include_exclude_flag='I'
2479: AND paf.assignment_status_type_id = TO_NUMBER(prtd.criteria_value1)

Line 2549: (SELECT 1 FROM per_assignments_f paf, pay_people_groups ppg, per_assignment_status_types past

2545: --- replaced non-performant delete stmnt for 4429787
2546:
2547: g_exec_string := 'delete from psp_selected_persons_t sel where request_id = :request_id
2548: AND NOT EXISTS
2549: (SELECT 1 FROM per_assignments_f paf, pay_people_groups ppg, per_assignment_status_types past
2550: WHERE paf.people_group_id= ppg.people_group_id
2551: AND paf.assignment_type = ''' || 'E' || '''
2552: AND paf.effective_end_date >= :p_effort_Start AND
2553: paf.effective_start_date <= :p_effort_end

Line 2711: per_assignment_status_types past

2707: AND person_id IN (SELECT ppf.person_id
2708: FROM per_people_f ppf,
2709: psp_report_template_details_h prtd,
2710: per_assignments_f paf,
2711: per_assignment_status_types past
2712: WHERE criteria_lookup_type='PSP_SELECTION_CRITERIA'
2713: AND criteria_lookup_code='PTY'
2714: AND paf.person_id = ppf.person_id
2715: AND paf.assignment_type = 'E'

Line 2749: per_assignment_status_types past

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
2752: WHERE prtd.criteria_lookup_type='PSP_SELECTION_CRITERIA'
2753: AND criteria_lookup_code='EMP'

Line 2788: per_assignment_status_types past

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'
2791: AND include_exclude_flag='E'
2792: AND paf.supervisor_id = TO_NUMBER(prtd.criteria_value1)

Line 2974: per_assignment_status_types past

2970: WHERE request_id = p_request_id
2971: AND person_id IN (SELECT person_id
2972: FROM per_assignments_f paf,
2973: psp_report_template_details_h prtd,
2974: per_assignment_status_types past
2975: WHERE criteria_lookup_type='PSP_SELECTION_CRITERIA'
2976: AND criteria_lookup_code='PAY'
2977: AND include_exclude_flag='E'
2978: AND paf.assignment_type = 'E'

Line 3009: per_assignment_status_types past

3005: WHERE request_id = p_request_id
3006: AND person_id IN (SELECT person_id
3007: FROM per_assignments_f paf,
3008: psp_report_template_details_h prtd,
3009: per_assignment_status_types past
3010: WHERE criteria_lookup_type='PSP_SELECTION_CRITERIA'
3011: AND criteria_lookup_code='LOC'
3012: AND include_exclude_flag='E'
3013: AND paf.assignment_type = 'E'

Line 3044: per_assignment_status_types past

3040: WHERE request_id = p_request_id
3041: AND person_id IN (SELECT person_id
3042: FROM per_assignments_f paf,
3043: psp_report_template_details_h prtd,
3044: per_assignment_status_types past
3045: WHERE criteria_lookup_type='PSP_SELECTION_CRITERIA'
3046: AND criteria_lookup_code='ORG'
3047: AND include_exclude_flag='E'
3048: AND paf.assignment_type = 'E'

Line 3083: per_assignment_status_types past

3079: WHERE request_id = p_request_id
3080: AND person_id IN (SELECT person_id
3081: FROM per_assignments_f paf,
3082: psp_report_template_details_h prtd,
3083: per_assignment_status_types past
3084: WHERE criteria_lookup_type='PSP_SELECTION_CRITERIA'
3085: AND criteria_lookup_code='JOB'
3086: AND include_exclude_flag='E'
3087: AND paf.assignment_type = 'E'

Line 3118: per_assignment_status_types past

3114: WHERE request_id = p_request_id
3115: AND person_id IN (SELECT person_id
3116: FROM per_assignments_f paf,
3117: psp_report_template_details_h prtd,
3118: per_assignment_status_types past
3119: WHERE criteria_lookup_type='PSP_SELECTION_CRITERIA'
3120: AND criteria_lookup_code='POS'
3121: AND include_exclude_flag='E'
3122: AND paf.assignment_type = 'E'

Line 3152: per_assignment_status_types past

3148: WHERE request_id = p_request_id
3149: AND person_id IN (SELECT person_id
3150: FROM per_assignments_f paf,
3151: psp_report_template_details_h prtd,
3152: per_assignment_status_types past
3153: WHERE criteria_lookup_type='PSP_SELECTION_CRITERIA'
3154: AND criteria_lookup_code='ASS'
3155: AND include_exclude_flag='E'
3156: AND paf.assignment_type = 'E'

Line 3187: per_assignment_status_types past

3183: WHERE request_id = p_request_id
3184: AND person_id IN (SELECT NVL(person_id,0)
3185: FROM per_assignments_f paf,
3186: pay_payrolls_f ppf,
3187: per_assignment_status_types past
3188: WHERE ppf.payroll_id = paf.payroll_id
3189: AND ppf.consolidation_set_id IN (SELECT TO_NUMBER(criteria_value1)
3190: FROM psp_report_template_details_h prtd
3191: WHERE criteria_lookup_type='PSP_SELECTION_CRITERIA'

Line 3228: per_assignment_status_types past

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'
3232: AND criteria_lookup_code='AST'

Line 3308: pay_people_groups ppg , per_assignment_status_types past

3304: IF l_sql_string is not null then
3305:
3306: g_exec_string := 'delete from psp_selected_persons_t where person_id
3307: in (select person_id from per_assignments_f paf,
3308: pay_people_groups ppg , per_assignment_status_types past
3309: where paf.people_group_id= ppg.people_group_id
3310: AND paf.assignment_type = ''' || 'E' || '''
3311: and paf.effective_end_date >= :p_effort_Start and
3312: paf.effective_start_date <= :p_effort_end

Line 4169: per_assignment_status_types past

4165: INSERT INTO psp_selected_persons_t (request_id, person_id, assignment_id)
4166: SELECT DISTINCT p_request_id, paf.person_id, paf.assignment_id
4167: FROM per_people_f ppf,
4168: per_assignments_f paf,
4169: per_assignment_status_types past
4170: WHERE person_type_id IN (SELECT TO_NUMBER(criteria_value1)
4171: FROM psp_report_template_details_h prtd
4172: WHERE prtd.criteria_lookup_type='PSP_SELECTION_CRITERIA'
4173: AND criteria_lookup_code='PTY'

Line 4206: per_assignment_status_types past

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
4209: WHERE prtd.criteria_lookup_type='PSP_SELECTION_CRITERIA'
4210: AND criteria_lookup_code='EMP'

Line 4242: per_assignment_status_types past

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'
4246: AND criteria_lookup_code='SUP'

Line 4422: per_assignment_status_types past

4418:
4419: INSERT INTO psp_selected_persons_t (request_id, person_id, assignment_id)
4420: SELECT DISTINCT p_request_id, paf.person_id, paf.assignment_id
4421: FROM per_assignments_f paf,
4422: per_assignment_status_types past
4423: WHERE payroll_id IN (SELECT TO_NUMBER(criteria_value1)
4424: FROM psp_report_template_details_h prtd
4425: WHERE criteria_lookup_type='PSP_SELECTION_CRITERIA'
4426: AND criteria_lookup_code='PAY'

Line 4455: per_assignment_status_types past

4451:
4452: INSERT INTO psp_selected_persons_t (request_id, person_id, assignment_id)
4453: SELECT DISTINCT p_request_id, paf.person_id, paf.assignment_id
4454: FROM per_assignments_f paf,
4455: per_assignment_status_types past
4456: WHERE location_id IN (SELECT TO_NUMBER(criteria_value1)
4457: FROM psp_report_template_details_h prtd
4458: WHERE criteria_lookup_type='PSP_SELECTION_CRITERIA'
4459: AND criteria_lookup_code='LOC'

Line 4487: per_assignment_status_types past

4483: ELSIF g_lookup_code ='ORG' THEN
4484: INSERT INTO psp_selected_persons_t (request_id, person_id, assignment_id)
4485: SELECT DISTINCT p_request_id, paf.person_id, paf.assignment_id
4486: FROM per_assignments_f paf,
4487: per_assignment_status_types past
4488: WHERE organization_id IN (SELECT TO_NUMBER(criteria_value1)
4489: FROM psp_report_template_details_h prtd
4490: WHERE criteria_lookup_type='PSP_SELECTION_CRITERIA'
4491: AND criteria_lookup_code='ORG'

Line 4520: per_assignment_status_types past

4516: INSERT INTO psp_selected_persons_t (request_id, person_id, assignment_id)
4517: SELECT DISTINCT p_request_id, person_id, assignment_id
4518: FROM per_assignments_f paf,
4519: pay_payrolls_f ppf,
4520: per_assignment_status_types past
4521: WHERE ppf.payroll_id = paf.payroll_id
4522: AND ppf.consolidation_set_id IN (SELECT TO_NUMBER(criteria_value1)
4523: FROM psp_report_template_details_h prtd
4524: WHERE criteria_lookup_type='PSP_SELECTION_CRITERIA'

Line 4558: per_assignment_status_types past

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'
4562: AND criteria_lookup_code='AST'

Line 4604: per_assignment_status_types past

4600:
4601: INSERT INTO psp_selected_persons_t (request_id, person_id, assignment_id)
4602: SELECT DISTINCT p_request_id, paf.person_id, paf.assignment_id
4603: FROM per_assignments_f paf,
4604: per_assignment_status_types past
4605: WHERE job_id IN (SELECT TO_NUMBER(criteria_value1)
4606: FROM psp_report_template_details_h prtd
4607: WHERE criteria_lookup_type='PSP_SELECTION_CRITERIA'
4608: AND criteria_lookup_code='JOB'

Line 4636: per_assignment_status_types past

4632: ELSIF g_lookup_code ='POS' THEN
4633: INSERT INTO psp_selected_persons_t (request_id, person_id, assignment_id)
4634: SELECT DISTINCT p_request_id, paf.person_id, paf.assignment_id
4635: FROM per_assignments_f paf,
4636: per_assignment_status_types past
4637: WHERE position_id IN (SELECT TO_NUMBER(criteria_value1)
4638: FROM psp_report_template_details_h prtd
4639: WHERE criteria_lookup_type='PSP_SELECTION_CRITERIA'
4640: AND criteria_lookup_code='POS'

Line 4668: per_assignment_status_types past

4664: ELSIF g_lookup_code ='ASS' THEN
4665: INSERT INTO psp_selected_persons_t (request_id, person_id, assignment_id)
4666: SELECT DISTINCT p_request_id, paf.person_id, paf.assignment_id
4667: FROM per_assignments_f paf,
4668: per_assignment_status_types past
4669: WHERE paf.assignment_status_type_id IN (SELECT TO_NUMBER(criteria_value1)
4670: FROM psp_report_template_details_h prtd
4671: WHERE criteria_lookup_type='PSP_SELECTION_CRITERIA'
4672: AND criteria_lookup_code='ASS'

Line 4718: per_assignment_status_types past

4714: g_exec_string := 'INSERT INTO psp_selected_persons_t (request_id, person_id, assignment_id)
4715: SELECT :request_id , person_id, assignment_id
4716: FROM per_assignments_f paf,
4717: pay_people_groups ppg,
4718: per_assignment_status_types past
4719: WHERE paf.people_group_id= ppg.people_group_id
4720: AND paf.assignment_type = ''' || 'E' || '''
4721: AND paf.effective_end_date >= :p_effort_start
4722: AND paf.effective_start_date <= :p_effort_end