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.

[Home] [Help]

APPS.PSP_TEMPLATE_SELECTION dependencies on HR_ASSIGNMENT_SET_AMENDMENTS

Line 770: hr_assignment_Set_amendments hasa

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
774: prtd where

Line 792: and not exists (select assignment_id from hr_assignment_Set_amendments hasa where

788: paf.effective_start_date <= p_effort_end and
789: paf.effective_end_date >= p_effort_start
790: AND paf.assignment_type = 'E'
791: and hasa.assignment_Set_id=has.assignment_Set_id and include_or_exclude ='I') )
792: and not exists (select assignment_id from hr_assignment_Set_amendments hasa where
793: hasa.assignment_id = paf.assignment_id and hasa.include_or_exclude ='E'
794: AND paf.assignment_type = 'E'
795: and paf.effective_start_date <= p_effort_end and
796: paf.effective_end_date >= p_effort_start

Line 1499: hr_assignment_set_amendments hasa,

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
1502: WHERE has.assignment_set_id IN (SELECT TO_NUMBER(criteria_value1)
1503: FROM psp_report_template_details_h prtd

Line 1519: FROM hr_assignment_set_amendments hasa

1515: AND paf.effective_start_date <= p_effort_end
1516: AND paf.effective_end_date >= p_effort_start
1517: AND hasa.assignment_set_id=has.assignment_set_id AND include_or_exclude ='I'))
1518: AND NOT EXISTS (SELECT assignment_id
1519: FROM hr_assignment_set_amendments hasa
1520: WHERE hasa.assignment_id = paf.assignment_id AND hasa.include_or_exclude ='E'
1521: AND paf.assignment_type = 'E'
1522: AND paf.effective_start_date <= p_effort_end
1523: AND paf.effective_end_date >= p_effort_start)

Line 2312: hr_assignment_set_amendments hasa,

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

Line 2332: FROM hr_assignment_set_amendments hasa

2328: AND paf.effective_end_date >= p_effort_start
2329: AND hasa.assignment_set_id=has.assignment_set_id
2330: AND include_or_exclude ='I'))
2331: AND NOT EXISTS (SELECT assignment_id
2332: FROM hr_assignment_set_amendments hasa
2333: WHERE hasa.assignment_id = paf.assignment_id
2334: AND paf.assignment_type = 'E'
2335: AND hasa.include_or_exclude ='E'
2336: AND paf.effective_start_date <= p_effort_end

Line 3194: hr_assignment_set_amendments hasa,

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

Line 3214: FROM hr_assignment_set_amendments hasa

3210: AND paf.effective_end_date >= p_effort_start
3211: AND hasa.assignment_set_id=has.assignment_set_id
3212: AND include_or_exclude ='I'))
3213: AND NOT EXISTS (SELECT assignment_id
3214: FROM hr_assignment_set_amendments hasa
3215: WHERE hasa.assignment_id = paf.assignment_id
3216: AND paf.assignment_type = 'E'
3217: AND hasa.include_or_exclude ='E'
3218: AND paf.effective_start_date <= p_effort_end

Line 3931: hr_assignment_set_amendments hasa

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
3934: WHERE criteria_lookup_type='PSP_SELECTION_CRITERIA'
3935: AND criteria_lookup_code='AST'

Line 3950: FROM hr_assignment_set_amendments hasa

3946: AND paf.effective_end_date >= p_effort_start
3947: AND hasa.assignment_set_id=has.assignment_set_id
3948: AND include_or_exclude ='I'))
3949: AND NOT EXISTS (SELECT assignment_id
3950: FROM hr_assignment_set_amendments hasa
3951: WHERE hasa.assignment_id = paf.assignment_id
3952: AND hasa.include_or_exclude ='E'
3953: AND paf.assignment_type = 'E'
3954: AND paf.effective_start_date <= p_effort_end

Line 4524: hr_assignment_set_amendments hasa,

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

Line 4543: FROM hr_assignment_set_amendments hasa

4539: AND paf.effective_start_date <= p_effort_end
4540: AND paf.effective_end_date >= p_effort_start
4541: AND hasa.assignment_set_id=has.assignment_set_id AND include_or_exclude ='I'))
4542: AND NOT EXISTS (SELECT assignment_id
4543: FROM hr_assignment_set_amendments hasa
4544: WHERE hasa.assignment_id = paf.assignment_id AND hasa.include_or_exclude ='E'
4545: AND paf.assignment_type = 'E'
4546: AND paf.effective_start_date <= p_effort_end
4547: AND paf.effective_end_date >= p_effort_start)

Line 5137: hr_assignment_set_amendments hasa

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
5140: WHERE criteria_lookup_type='PSP_SELECTION_CRITERIA'
5141: AND criteria_lookup_code='AST'

Line 5156: FROM hr_assignment_set_amendments hasa

5152: AND paf.effective_end_date >= p_effort_start
5153: AND hasa.assignment_set_id=has.assignment_set_id
5154: AND include_or_exclude ='I'))
5155: AND NOT EXISTS (SELECT assignment_id
5156: FROM hr_assignment_set_amendments hasa
5157: WHERE hasa.assignment_id = paf.assignment_id
5158: AND paf.assignment_type = 'E'
5159: AND hasa.include_or_exclude ='E'
5160: AND paf.effective_start_date <= p_effort_end

Line 5657: hr_assignment_set_amendments hasa

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

Line 5676: FROM hr_assignment_set_amendments hasa

5672: AND paf.effective_end_date >= p_effort_start
5673: AND hasa.assignment_set_id=has.assignment_set_id
5674: AND include_or_exclude ='I'))
5675: AND NOT EXISTS (SELECT assignment_id
5676: FROM hr_assignment_set_amendments hasa
5677: WHERE hasa.assignment_id = paf.assignment_id
5678: AND paf.assignment_type = 'E'
5679: AND hasa.include_or_exclude ='E'
5680: AND paf.effective_start_date <= p_effort_end