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 2304: pay_payrolls_f ppf,

2300: /* Bug 5087294 : Performance fix replacing not in with not exists */
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

Line 3186: pay_payrolls_f ppf,

3182: DELETE FROM psp_selected_persons_t
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

Line 3945: pay_payrolls_f ppf

3941: INSERT INTO psp_selection_cardinality_gt
3942: (lookup_code, total_count)
3943: SELECT 'CST', COUNT(DISTINCT paf.assignment_id)
3944: FROM per_assignments_f paf,
3945: pay_payrolls_f ppf
3946: WHERE ppf.payroll_id = paf.payroll_id
3947: AND ppf.consolidation_set_id IN (SELECT TO_NUMBER(criteria_value1)
3948: FROM psp_report_template_details_h prtd
3949: WHERE criteria_lookup_type='PSP_SELECTION_CRITERIA'

Line 4519: pay_payrolls_f ppf,

4515: ELSIF g_lookup_code='CST' THEN
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

Line 5150: pay_payrolls_f ppf

5146: /* Bug 5087294 : Performance fix replacing not in with not exists */
5147: -- AND assignment_id NOT IN (SELECT NVL(assignment_id,0)
5148: AND NOT EXISTS ( SELECT 1
5149: FROM per_assignments_f paf,
5150: pay_payrolls_f ppf
5151: WHERE ppf.payroll_id = paf.payroll_id
5152: AND ppf.consolidation_set_id IN (SELECT TO_NUMBER(criteria_value1)
5153: FROM psp_report_template_details_h prtd
5154: WHERE criteria_lookup_type='PSP_SELECTION_CRITERIA'

Line 5672: pay_payrolls_f ppf

5668: DELETE FROM psp_selected_persons_t
5669: WHERE request_id = p_request_id
5670: AND assignment_id IN (SELECT NVL(assignment_id,0)
5671: FROM per_assignments_f paf,
5672: pay_payrolls_f ppf
5673: WHERE ppf.payroll_id = paf.payroll_id
5674: AND ppf.consolidation_set_id IN (SELECT TO_NUMBER(criteria_value1)
5675: FROM psp_report_template_details_h prtd
5676: WHERE criteria_lookup_type='PSP_SELECTION_CRITERIA'