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 PAY_ELEMENT_TYPE_RULES

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 5306: (select petr1.element_type_id from pay_element_type_rules petr1,

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
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 )

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 5341: (select petr1.element_type_id from pay_element_type_rules petr1,

5337: prth1.criteria_lookup_code='EST' and prth1.request_id =per.request_id and
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

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 5381: (select petr1.element_type_id from pay_element_type_rules petr1,

5377: prth1.criteria_lookup_code='EST' and prth1.request_id =per.request_id and
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

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 5425: (select petr1.element_type_id from pay_element_type_rules petr1,

5421: prth1.criteria_lookup_code='EST' and prth1.request_id =per.request_id
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

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 5459: (select petr1.element_type_id from pay_element_type_rules petr1,

5455: prth1.criteria_lookup_code='EST' and prth1.request_id =per.request_id
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

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 5496: (select petr1.element_type_id from pay_element_type_rules petr1,

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
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 )

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 5534: (select petr1.element_type_id from pay_element_type_rules petr1,

5530: prth1.criteria_lookup_code='EST' and prth1.request_id =per.request_id
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

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 5577: (select petr1.element_type_id from pay_element_type_rules petr1,

5573: prth1.criteria_lookup_code='EST' and prth1.request_id =per.request_id
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

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 5625: (select petr1.element_type_id from pay_element_type_rules petr1,

5621: and prth1.criteria_lookup_code='EST' and prth1.request_id =per.request_id
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

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 5662: (select petr1.element_type_id from pay_element_type_rules petr1,

5658: and prth1.criteria_lookup_code='EST' and prth1.request_id =per.request_id
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