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_SUM_TRANS dependencies on PSP_REPORT_TEMPLATE_DETAILS_H

Line 5295: ((select petr.element_type_id from pay_element_type_rules petr, psp_report_template_details_h prth where

5291: And pal.person_id = per.person_id
5292: And ppc.payroll_control_id = pal.payroll_control_id
5293: And per.status_code not in ('S','R')
5294: And pal.element_type_id in
5295: ((select petr.element_type_id from pay_element_type_rules petr, psp_report_template_details_h prth where
5296: petr.include_or_exclude ='I' and
5297: prth.request_id =per.request_id and prth.criteria_lookup_code='EST' and
5298: petr.element_Set_id = prth.criteria_value1 )
5299: union all (select pet1.element_type_id from

Line 5301: psp_report_template_details_h prth1

5297: prth.request_id =per.request_id and prth.criteria_lookup_code='EST' and
5298: petr.element_Set_id = prth.criteria_value1 )
5299: union all (select pet1.element_type_id from
5300: pay_element_types_f pet1, pay_ele_classification_rules pecr,
5301: psp_report_template_details_h prth1
5302: where pet1.classification_id = pecr.classification_id and
5303: prth1.criteria_lookup_code='EST' and prth1.request_id =per.request_id and
5304: pecr.element_Set_id = prth1.criteria_value1 ))
5305: And pal.element_type_id not in

Line 5307: psp_report_template_Details_h prth2

5303: prth1.criteria_lookup_code='EST' and prth1.request_id =per.request_id and
5304: pecr.element_Set_id = prth1.criteria_value1 ))
5305: And pal.element_type_id not in
5306: (select petr1.element_type_id from pay_element_type_rules petr1,
5307: psp_report_template_Details_h prth2
5308: where petr1.include_or_exclude='E'
5309: and prth2.request_id = per.request_id
5310: and prth2.criteria_lookup_code='EST' and prth2.criteria_value1= petr1.element_Set_id )
5311: group by per.person_id, per.effort_report_id;

Line 5327: ((select petr.element_type_id from pay_element_type_rules petr, psp_report_template_details_h prth where

5323: And pregen.person_id = per.person_id
5324: And ppc.payroll_control_id = pregen.payroll_control_id
5325: And per.status_code not in ('S','R')
5326: And pregen.element_type_id in
5327: ((select petr.element_type_id from pay_element_type_rules petr, psp_report_template_details_h prth where
5328: petr.include_or_exclude ='I' and
5329: prth.request_id =per.request_id and prth.criteria_lookup_code='EST' and
5330: petr.element_Set_id = prth.criteria_value1
5331: )

Line 5335: psp_report_template_details_h prth1

5331: )
5332: union all
5333: (select pet1.element_type_id from
5334: pay_element_types_f pet1, pay_ele_classification_rules pecr,
5335: psp_report_template_details_h prth1
5336: where pet1.classification_id = pecr.classification_id and
5337: prth1.criteria_lookup_code='EST' and prth1.request_id =per.request_id and
5338: pecr.element_Set_id = prth1.criteria_value1
5339: ))

Line 5342: psp_report_template_Details_h prth2

5338: pecr.element_Set_id = prth1.criteria_value1
5339: ))
5340: And pregen.element_type_id not in
5341: (select petr1.element_type_id from pay_element_type_rules petr1,
5342: psp_report_template_Details_h prth2
5343: where petr1.include_or_exclude='E'
5344: and prth2.request_id = per.request_id
5345: and prth2.criteria_lookup_code='EST' and prth2.criteria_value1= petr1.element_Set_id
5346: )

Line 5367: ((select petr.element_type_id from pay_element_type_rules petr, psp_report_template_details_h prth where

5363: And ppc.run_id = p_run_id
5364: And ppc.payroll_control_id = ppl.payroll_control_id
5365: And per.status_code not in ('S','R')
5366: And ppl.element_type_id in
5367: ((select petr.element_type_id from pay_element_type_rules petr, psp_report_template_details_h prth where
5368: petr.include_or_exclude ='I' and
5369: prth.request_id =per.request_id and prth.criteria_lookup_code='EST' and
5370: petr.element_Set_id = prth.criteria_value1
5371: )

Line 5375: psp_report_template_details_h prth1

5371: )
5372: union all
5373: (select pet1.element_type_id from
5374: pay_element_types_f pet1, pay_ele_classification_rules pecr,
5375: psp_report_template_details_h prth1
5376: where pet1.classification_id = pecr.classification_id and
5377: prth1.criteria_lookup_code='EST' and prth1.request_id =per.request_id and
5378: pecr.element_Set_id = prth1.criteria_value1
5379: ))

Line 5382: psp_report_template_Details_h prth2

5378: pecr.element_Set_id = prth1.criteria_value1
5379: ))
5380: And ppl.element_type_id not in
5381: (select petr1.element_type_id from pay_element_type_rules petr1,
5382: psp_report_template_Details_h prth2
5383: where petr1.include_or_exclude='E'
5384: and prth2.request_id = per.request_id
5385: and prth2.criteria_lookup_code='EST' and prth2.criteria_value1= petr1.element_Set_id
5386: )

Line 5411: ((select petr.element_type_id from pay_element_type_rules petr, psp_report_template_details_h prth where

5407: And ppc.run_id = p_run_id
5408: And ppc.payroll_control_id = ppl.payroll_control_id
5409: And per.status_code not in ('S','R')
5410: And ppl.element_type_id in
5411: ((select petr.element_type_id from pay_element_type_rules petr, psp_report_template_details_h prth where
5412: petr.include_or_exclude ='I' and
5413: prth.request_id =per.request_id and prth.criteria_lookup_code='EST' and
5414: petr.element_Set_id = prth.criteria_value1
5415: )

Line 5419: psp_report_template_details_h prth1

5415: )
5416: union all
5417: (select pet1.element_type_id from
5418: pay_element_types_f pet1, pay_ele_classification_rules pecr,
5419: psp_report_template_details_h prth1
5420: where pet1.classification_id = pecr.classification_id and
5421: prth1.criteria_lookup_code='EST' and prth1.request_id =per.request_id
5422: and pecr.element_Set_id = prth1.criteria_value1
5423: ))

Line 5426: psp_report_template_Details_h prth2

5422: and pecr.element_Set_id = prth1.criteria_value1
5423: ))
5424: And ppl.element_type_id not in
5425: (select petr1.element_type_id from pay_element_type_rules petr1,
5426: psp_report_template_Details_h prth2
5427: where petr1.include_or_exclude='E'
5428: and prth2.request_id = per.request_id
5429: and prth2.criteria_lookup_code='EST' and prth2.criteria_value1= petr1.element_Set_id
5430: )

Line 5445: ((select petr.element_type_id from pay_element_type_rules petr, psp_report_template_details_h prth where

5441: And pregen.person_id = per.person_id
5442: And ppc.payroll_control_id = pregen.payroll_control_id
5443: And per.status_code not in ('S','R')
5444: And pregen.element_type_id in
5445: ((select petr.element_type_id from pay_element_type_rules petr, psp_report_template_details_h prth where
5446: petr.include_or_exclude ='I' and
5447: prth.request_id =per.request_id and prth.criteria_lookup_code='EST'
5448: and petr.element_Set_id = prth.criteria_value1
5449: )

Line 5453: psp_report_template_details_h prth1

5449: )
5450: union all
5451: (select pet1.element_type_id from
5452: pay_element_types_f pet1, pay_ele_classification_rules pecr,
5453: psp_report_template_details_h prth1
5454: where pet1.classification_id = pecr.classification_id and
5455: prth1.criteria_lookup_code='EST' and prth1.request_id =per.request_id
5456: and pecr.element_Set_id = prth1.criteria_value1
5457: ))

Line 5460: psp_report_template_Details_h prth2

5456: and pecr.element_Set_id = prth1.criteria_value1
5457: ))
5458: And pregen.element_type_id not in
5459: (select petr1.element_type_id from pay_element_type_rules petr1,
5460: psp_report_template_Details_h prth2
5461: where petr1.include_or_exclude='E'
5462: and prth2.request_id = per.request_id
5463: and prth2.criteria_lookup_code='EST' and prth2.criteria_value1= petr1.element_Set_id
5464: ))

Line 5485: ((select petr.element_type_id from pay_element_type_rules petr, psp_report_template_details_h prth where

5481: And pal.person_id = per.person_id
5482: And ppc.payroll_control_id = pal.payroll_control_id
5483: And per.status_code not in ('S','R')
5484: And pal.element_type_id in
5485: ((select petr.element_type_id from pay_element_type_rules petr, psp_report_template_details_h prth where
5486: petr.include_or_exclude ='I'
5487: and prth.request_id =per.request_id and prth.criteria_lookup_code='EST'
5488: and petr.element_Set_id = prth.criteria_value1 )
5489: union all (select pet1.element_type_id from

Line 5491: psp_report_template_details_h prth1

5487: and prth.request_id =per.request_id and prth.criteria_lookup_code='EST'
5488: and petr.element_Set_id = prth.criteria_value1 )
5489: union all (select pet1.element_type_id from
5490: pay_element_types_f pet1, pay_ele_classification_rules pecr,
5491: psp_report_template_details_h prth1
5492: where pet1.classification_id = pecr.classification_id
5493: and prth1.criteria_lookup_code='EST' and prth1.request_id =per.request_id
5494: and pecr.element_Set_id = prth1.criteria_value1 ))
5495: And pal.element_type_id not in

Line 5497: psp_report_template_Details_h prth2

5493: and prth1.criteria_lookup_code='EST' and prth1.request_id =per.request_id
5494: and pecr.element_Set_id = prth1.criteria_value1 ))
5495: And pal.element_type_id not in
5496: (select petr1.element_type_id from pay_element_type_rules petr1,
5497: psp_report_template_Details_h prth2
5498: where petr1.include_or_exclude='E'
5499: and prth2.request_id = per.request_id
5500: and prth2.criteria_lookup_code='EST' and prth2.criteria_value1= petr1.element_Set_id )
5501: group by per.person_id, per.effort_report_id;

Line 5520: ((select petr.element_type_id from pay_element_type_rules petr, psp_report_template_details_h prth where

5516: And pregen.person_id = per.person_id
5517: And ppc.payroll_control_id = pregen.payroll_control_id
5518: And per.status_code not in ('S','R')
5519: And pregen.element_type_id in
5520: ((select petr.element_type_id from pay_element_type_rules petr, psp_report_template_details_h prth where
5521: petr.include_or_exclude ='I' and
5522: prth.request_id =per.request_id and prth.criteria_lookup_code='EST'
5523: and petr.element_Set_id = prth.criteria_value1
5524: )

Line 5528: psp_report_template_details_h prth1

5524: )
5525: union all
5526: (select pet1.element_type_id from
5527: pay_element_types_f pet1, pay_ele_classification_rules pecr,
5528: psp_report_template_details_h prth1
5529: where pet1.classification_id = pecr.classification_id and
5530: prth1.criteria_lookup_code='EST' and prth1.request_id =per.request_id
5531: and pecr.element_Set_id = prth1.criteria_value1
5532: ))

Line 5535: psp_report_template_Details_h prth2

5531: and pecr.element_Set_id = prth1.criteria_value1
5532: ))
5533: And pregen.element_type_id not in
5534: (select petr1.element_type_id from pay_element_type_rules petr1,
5535: psp_report_template_Details_h prth2
5536: where petr1.include_or_exclude='E'
5537: and prth2.request_id = per.request_id
5538: and prth2.criteria_lookup_code='EST' and prth2.criteria_value1= petr1.element_Set_id
5539: )

Line 5563: ((select petr.element_type_id from pay_element_type_rules petr, psp_report_template_details_h prth where

5559: And ppc.run_id = p_run_id
5560: And ppc.payroll_control_id = ppl.payroll_control_id
5561: And per.status_code not in ('S','R')
5562: And ppl.element_type_id in
5563: ((select petr.element_type_id from pay_element_type_rules petr, psp_report_template_details_h prth where
5564: petr.include_or_exclude ='I'
5565: and prth.request_id =per.request_id and prth.criteria_lookup_code='EST'
5566: and petr.element_Set_id = prth.criteria_value1
5567: )

Line 5571: psp_report_template_details_h prth1

5567: )
5568: union all
5569: (select pet1.element_type_id from
5570: pay_element_types_f pet1, pay_ele_classification_rules pecr,
5571: psp_report_template_details_h prth1
5572: where pet1.classification_id = pecr.classification_id and
5573: prth1.criteria_lookup_code='EST' and prth1.request_id =per.request_id
5574: and pecr.element_Set_id = prth1.criteria_value1
5575: ))

Line 5578: psp_report_template_Details_h prth2

5574: and pecr.element_Set_id = prth1.criteria_value1
5575: ))
5576: And ppl.element_type_id not in
5577: (select petr1.element_type_id from pay_element_type_rules petr1,
5578: psp_report_template_Details_h prth2
5579: where petr1.include_or_exclude='E'
5580: and prth2.request_id = per.request_id
5581: and prth2.criteria_lookup_code='EST' and prth2.criteria_value1= petr1.element_Set_id
5582: )

Line 5611: ((select petr.element_type_id from pay_element_type_rules petr, psp_report_template_details_h prth where

5607: And ppc.run_id = p_run_id
5608: And ppc.payroll_control_id = ppl.payroll_control_id
5609: And per.status_code not in ('S','R')
5610: And ppl.element_type_id in
5611: ((select petr.element_type_id from pay_element_type_rules petr, psp_report_template_details_h prth where
5612: petr.include_or_exclude ='I' and
5613: prth.request_id =per.request_id and prth.criteria_lookup_code='EST'
5614: and petr.element_Set_id = prth.criteria_value1
5615: )

Line 5619: psp_report_template_details_h prth1

5615: )
5616: union all
5617: (select pet1.element_type_id from
5618: pay_element_types_f pet1, pay_ele_classification_rules pecr,
5619: psp_report_template_details_h prth1
5620: where pet1.classification_id = pecr.classification_id
5621: and prth1.criteria_lookup_code='EST' and prth1.request_id =per.request_id
5622: and pecr.element_Set_id = prth1.criteria_value1
5623: ))

Line 5626: psp_report_template_Details_h prth2

5622: and pecr.element_Set_id = prth1.criteria_value1
5623: ))
5624: And ppl.element_type_id not in
5625: (select petr1.element_type_id from pay_element_type_rules petr1,
5626: psp_report_template_Details_h prth2
5627: where petr1.include_or_exclude='E'
5628: and prth2.request_id = per.request_id
5629: and prth2.criteria_lookup_code='EST' and prth2.criteria_value1= petr1.element_Set_id
5630: )

Line 5648: ((select petr.element_type_id from pay_element_type_rules petr, psp_report_template_details_h prth where

5644: And pregen.person_id = per.person_id
5645: And ppc.payroll_control_id = pregen.payroll_control_id
5646: And per.status_code not in ('S','R')
5647: And pregen.element_type_id in
5648: ((select petr.element_type_id from pay_element_type_rules petr, psp_report_template_details_h prth where
5649: petr.include_or_exclude ='I'
5650: and prth.request_id =per.request_id and prth.criteria_lookup_code='EST'
5651: and petr.element_Set_id = prth.criteria_value1
5652: )

Line 5656: psp_report_template_details_h prth1

5652: )
5653: union all
5654: (select pet1.element_type_id from
5655: pay_element_types_f pet1, pay_ele_classification_rules pecr,
5656: psp_report_template_details_h prth1
5657: where pet1.classification_id = pecr.classification_id
5658: and prth1.criteria_lookup_code='EST' and prth1.request_id =per.request_id
5659: and pecr.element_Set_id = prth1.criteria_value1
5660: ))

Line 5663: psp_report_template_Details_h prth2

5659: and pecr.element_Set_id = prth1.criteria_value1
5660: ))
5661: And pregen.element_type_id not in
5662: (select petr1.element_type_id from pay_element_type_rules petr1,
5663: psp_report_template_Details_h prth2
5664: where petr1.include_or_exclude='E'
5665: and prth2.request_id = per.request_id
5666: and prth2.criteria_lookup_code='EST' and prth2.criteria_value1= petr1.element_Set_id
5667: ))

Line 5756: psp_report_template_details_h dtl

5752: select distinct wf.name,
5753: wf.orig_system_id
5754: from wf_roles wf,
5755: psp_report_templates_h h,
5756: psp_report_template_details_h dtl
5757: where wf.orig_system = 'PER'
5758: and to_char(wf.orig_system_id) = dtl.criteria_value1
5759: and dtl.criteria_lookup_type = 'PSP_SELECTION_CRITERIA'
5760: and dtl.criteria_lookup_code = 'FRP'