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 PAY_PAYROLLS_F

Line 750: , pay_payrolls_f ppf where

746: ELSIF template_rec.array_sel_criteria(i)='CST' THEN
747:
748: insert into psp_selection_cardinality_gt(lookup_code, total_count) (
749: select 'CST', count(distinct paf.person_id) from per_assignments_f paf
750: , pay_payrolls_f ppf where
751: ppf.payroll_id = paf.payroll_id and
752: ppf.consolidation_set_id in
753: (select TO_NUMBER(criteria_value1) from psp_report_template_details_h
754: prtd where

Line 1456: FROM pay_payrolls_f pp,

1452: ELSIF g_lookup_code='CST' then
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

Line 2271: pay_payrolls_f ppf,

2267: /* Bug 5087294 : Performance fix replacing not in with not exists */
2268: -- AND assignment_id NOT IN (SELECT NVL(assignment_id,0)
2269: AND NOT EXISTS ( SELECT 1
2270: FROM per_assignments_f paf,
2271: pay_payrolls_f ppf,
2272: per_assignment_status_types past
2273: WHERE ppf.payroll_id = paf.payroll_id
2274: AND ppf.consolidation_set_id IN (SELECT TO_NUMBER(criteria_value1)
2275: FROM psp_report_template_details_h prtd

Line 3153: pay_payrolls_f ppf,

3149: DELETE FROM psp_selected_persons_t
3150: WHERE request_id = p_request_id
3151: AND person_id IN (SELECT NVL(person_id,0)
3152: FROM per_assignments_f paf,
3153: pay_payrolls_f ppf,
3154: per_assignment_status_types past
3155: WHERE ppf.payroll_id = paf.payroll_id
3156: AND ppf.consolidation_set_id IN (SELECT TO_NUMBER(criteria_value1)
3157: FROM psp_report_template_details_h prtd

Line 3912: pay_payrolls_f ppf

3908: INSERT INTO psp_selection_cardinality_gt
3909: (lookup_code, total_count)
3910: SELECT 'CST', COUNT(DISTINCT paf.assignment_id)
3911: FROM per_assignments_f paf,
3912: pay_payrolls_f ppf
3913: WHERE ppf.payroll_id = paf.payroll_id
3914: AND ppf.consolidation_set_id IN (SELECT TO_NUMBER(criteria_value1)
3915: FROM psp_report_template_details_h prtd
3916: WHERE criteria_lookup_type='PSP_SELECTION_CRITERIA'

Line 4486: pay_payrolls_f ppf,

4482: ELSIF g_lookup_code='CST' THEN
4483: INSERT INTO psp_selected_persons_t (request_id, person_id, assignment_id)
4484: SELECT DISTINCT p_request_id, person_id, assignment_id
4485: FROM per_assignments_f paf,
4486: pay_payrolls_f ppf,
4487: per_assignment_status_types past
4488: WHERE ppf.payroll_id = paf.payroll_id
4489: AND ppf.consolidation_set_id IN (SELECT TO_NUMBER(criteria_value1)
4490: FROM psp_report_template_details_h prtd

Line 5117: pay_payrolls_f ppf

5113: /* Bug 5087294 : Performance fix replacing not in with not exists */
5114: -- AND assignment_id NOT IN (SELECT NVL(assignment_id,0)
5115: AND NOT EXISTS ( SELECT 1
5116: FROM per_assignments_f paf,
5117: pay_payrolls_f ppf
5118: WHERE ppf.payroll_id = paf.payroll_id
5119: AND ppf.consolidation_set_id IN (SELECT TO_NUMBER(criteria_value1)
5120: FROM psp_report_template_details_h prtd
5121: WHERE criteria_lookup_type='PSP_SELECTION_CRITERIA'

Line 5639: pay_payrolls_f ppf

5635: DELETE FROM psp_selected_persons_t
5636: WHERE request_id = p_request_id
5637: AND assignment_id IN (SELECT NVL(assignment_id,0)
5638: FROM per_assignments_f paf,
5639: pay_payrolls_f ppf
5640: WHERE ppf.payroll_id = paf.payroll_id
5641: AND ppf.consolidation_set_id IN (SELECT TO_NUMBER(criteria_value1)
5642: FROM psp_report_template_details_h prtd
5643: WHERE criteria_lookup_type='PSP_SELECTION_CRITERIA'