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 5718: ((select petr.element_type_id from pay_element_type_rules petr, psp_report_template_details_h prth where

5714: And pal.person_id = per.person_id
5715: And ppc.payroll_control_id = pal.payroll_control_id
5716: And per.status_code not in ('S','R')
5717: And pal.element_type_id in
5718: ((select petr.element_type_id from pay_element_type_rules petr, psp_report_template_details_h prth where
5719: petr.include_or_exclude ='I' and
5720: prth.request_id =per.request_id and prth.criteria_lookup_code='EST' and
5721: petr.element_Set_id = prth.criteria_value1 )
5722: union all (select pet1.element_type_id from

Line 5729: (select petr1.element_type_id from pay_element_type_rules petr1,

5725: where pet1.classification_id = pecr.classification_id and
5726: prth1.criteria_lookup_code='EST' and prth1.request_id =per.request_id and
5727: pecr.element_Set_id = prth1.criteria_value1 ))
5728: And pal.element_type_id not in
5729: (select petr1.element_type_id from pay_element_type_rules petr1,
5730: psp_report_template_Details_h prth2
5731: where petr1.include_or_exclude='E'
5732: and prth2.request_id = per.request_id
5733: and prth2.criteria_lookup_code='EST' and prth2.criteria_value1= petr1.element_Set_id )

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

5746: And pregen.person_id = per.person_id
5747: And ppc.payroll_control_id = pregen.payroll_control_id
5748: And per.status_code not in ('S','R')
5749: And pregen.element_type_id in
5750: ((select petr.element_type_id from pay_element_type_rules petr, psp_report_template_details_h prth where
5751: petr.include_or_exclude ='I' and
5752: prth.request_id =per.request_id and prth.criteria_lookup_code='EST' and
5753: petr.element_Set_id = prth.criteria_value1
5754: )

Line 5764: (select petr1.element_type_id from pay_element_type_rules petr1,

5760: prth1.criteria_lookup_code='EST' and prth1.request_id =per.request_id and
5761: pecr.element_Set_id = prth1.criteria_value1
5762: ))
5763: And pregen.element_type_id not in
5764: (select petr1.element_type_id from pay_element_type_rules petr1,
5765: psp_report_template_Details_h prth2
5766: where petr1.include_or_exclude='E'
5767: and prth2.request_id = per.request_id
5768: and prth2.criteria_lookup_code='EST' and prth2.criteria_value1= petr1.element_Set_id

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

5786: And ppc.run_id = p_run_id
5787: And ppc.payroll_control_id = ppl.payroll_control_id
5788: And per.status_code not in ('S','R')
5789: And ppl.element_type_id in
5790: ((select petr.element_type_id from pay_element_type_rules petr, psp_report_template_details_h prth where
5791: petr.include_or_exclude ='I' and
5792: prth.request_id =per.request_id and prth.criteria_lookup_code='EST' and
5793: petr.element_Set_id = prth.criteria_value1
5794: )

Line 5804: (select petr1.element_type_id from pay_element_type_rules petr1,

5800: prth1.criteria_lookup_code='EST' and prth1.request_id =per.request_id and
5801: pecr.element_Set_id = prth1.criteria_value1
5802: ))
5803: And ppl.element_type_id not in
5804: (select petr1.element_type_id from pay_element_type_rules petr1,
5805: psp_report_template_Details_h prth2
5806: where petr1.include_or_exclude='E'
5807: and prth2.request_id = per.request_id
5808: and prth2.criteria_lookup_code='EST' and prth2.criteria_value1= petr1.element_Set_id

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

5830: And ppc.run_id = p_run_id
5831: And ppc.payroll_control_id = ppl.payroll_control_id
5832: And per.status_code not in ('S','R')
5833: And ppl.element_type_id in
5834: ((select petr.element_type_id from pay_element_type_rules petr, psp_report_template_details_h prth where
5835: petr.include_or_exclude ='I' and
5836: prth.request_id =per.request_id and prth.criteria_lookup_code='EST' and
5837: petr.element_Set_id = prth.criteria_value1
5838: )

Line 5848: (select petr1.element_type_id from pay_element_type_rules petr1,

5844: prth1.criteria_lookup_code='EST' and prth1.request_id =per.request_id
5845: and pecr.element_Set_id = prth1.criteria_value1
5846: ))
5847: And ppl.element_type_id not in
5848: (select petr1.element_type_id from pay_element_type_rules petr1,
5849: psp_report_template_Details_h prth2
5850: where petr1.include_or_exclude='E'
5851: and prth2.request_id = per.request_id
5852: and prth2.criteria_lookup_code='EST' and prth2.criteria_value1= petr1.element_Set_id

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

5864: And pregen.person_id = per.person_id
5865: And ppc.payroll_control_id = pregen.payroll_control_id
5866: And per.status_code not in ('S','R')
5867: And pregen.element_type_id in
5868: ((select petr.element_type_id from pay_element_type_rules petr, psp_report_template_details_h prth where
5869: petr.include_or_exclude ='I' and
5870: prth.request_id =per.request_id and prth.criteria_lookup_code='EST'
5871: and petr.element_Set_id = prth.criteria_value1
5872: )

Line 5882: (select petr1.element_type_id from pay_element_type_rules petr1,

5878: prth1.criteria_lookup_code='EST' and prth1.request_id =per.request_id
5879: and pecr.element_Set_id = prth1.criteria_value1
5880: ))
5881: And pregen.element_type_id not in
5882: (select petr1.element_type_id from pay_element_type_rules petr1,
5883: psp_report_template_Details_h prth2
5884: where petr1.include_or_exclude='E'
5885: and prth2.request_id = per.request_id
5886: and prth2.criteria_lookup_code='EST' and prth2.criteria_value1= petr1.element_Set_id

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

5904: And pal.person_id = per.person_id
5905: And ppc.payroll_control_id = pal.payroll_control_id
5906: And per.status_code not in ('S','R')
5907: And pal.element_type_id in
5908: ((select petr.element_type_id from pay_element_type_rules petr, psp_report_template_details_h prth where
5909: petr.include_or_exclude ='I'
5910: and prth.request_id =per.request_id and prth.criteria_lookup_code='EST'
5911: and petr.element_Set_id = prth.criteria_value1 )
5912: union all (select pet1.element_type_id from

Line 5919: (select petr1.element_type_id from pay_element_type_rules petr1,

5915: where pet1.classification_id = pecr.classification_id
5916: and prth1.criteria_lookup_code='EST' and prth1.request_id =per.request_id
5917: and pecr.element_Set_id = prth1.criteria_value1 ))
5918: And pal.element_type_id not in
5919: (select petr1.element_type_id from pay_element_type_rules petr1,
5920: psp_report_template_Details_h prth2
5921: where petr1.include_or_exclude='E'
5922: and prth2.request_id = per.request_id
5923: and prth2.criteria_lookup_code='EST' and prth2.criteria_value1= petr1.element_Set_id )

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

5939: And pregen.person_id = per.person_id
5940: And ppc.payroll_control_id = pregen.payroll_control_id
5941: And per.status_code not in ('S','R')
5942: And pregen.element_type_id in
5943: ((select petr.element_type_id from pay_element_type_rules petr, psp_report_template_details_h prth where
5944: petr.include_or_exclude ='I' and
5945: prth.request_id =per.request_id and prth.criteria_lookup_code='EST'
5946: and petr.element_Set_id = prth.criteria_value1
5947: )

Line 5957: (select petr1.element_type_id from pay_element_type_rules petr1,

5953: prth1.criteria_lookup_code='EST' and prth1.request_id =per.request_id
5954: and pecr.element_Set_id = prth1.criteria_value1
5955: ))
5956: And pregen.element_type_id not in
5957: (select petr1.element_type_id from pay_element_type_rules petr1,
5958: psp_report_template_Details_h prth2
5959: where petr1.include_or_exclude='E'
5960: and prth2.request_id = per.request_id
5961: and prth2.criteria_lookup_code='EST' and prth2.criteria_value1= petr1.element_Set_id

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

5982: And ppc.run_id = p_run_id
5983: And ppc.payroll_control_id = ppl.payroll_control_id
5984: And per.status_code not in ('S','R')
5985: And ppl.element_type_id in
5986: ((select petr.element_type_id from pay_element_type_rules petr, psp_report_template_details_h prth where
5987: petr.include_or_exclude ='I'
5988: and prth.request_id =per.request_id and prth.criteria_lookup_code='EST'
5989: and petr.element_Set_id = prth.criteria_value1
5990: )

Line 6000: (select petr1.element_type_id from pay_element_type_rules petr1,

5996: prth1.criteria_lookup_code='EST' and prth1.request_id =per.request_id
5997: and pecr.element_Set_id = prth1.criteria_value1
5998: ))
5999: And ppl.element_type_id not in
6000: (select petr1.element_type_id from pay_element_type_rules petr1,
6001: psp_report_template_Details_h prth2
6002: where petr1.include_or_exclude='E'
6003: and prth2.request_id = per.request_id
6004: and prth2.criteria_lookup_code='EST' and prth2.criteria_value1= petr1.element_Set_id

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

6030: And ppc.run_id = p_run_id
6031: And ppc.payroll_control_id = ppl.payroll_control_id
6032: And per.status_code not in ('S','R')
6033: And ppl.element_type_id in
6034: ((select petr.element_type_id from pay_element_type_rules petr, psp_report_template_details_h prth where
6035: petr.include_or_exclude ='I' and
6036: prth.request_id =per.request_id and prth.criteria_lookup_code='EST'
6037: and petr.element_Set_id = prth.criteria_value1
6038: )

Line 6048: (select petr1.element_type_id from pay_element_type_rules petr1,

6044: and prth1.criteria_lookup_code='EST' and prth1.request_id =per.request_id
6045: and pecr.element_Set_id = prth1.criteria_value1
6046: ))
6047: And ppl.element_type_id not in
6048: (select petr1.element_type_id from pay_element_type_rules petr1,
6049: psp_report_template_Details_h prth2
6050: where petr1.include_or_exclude='E'
6051: and prth2.request_id = per.request_id
6052: and prth2.criteria_lookup_code='EST' and prth2.criteria_value1= petr1.element_Set_id

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

6067: And pregen.person_id = per.person_id
6068: And ppc.payroll_control_id = pregen.payroll_control_id
6069: And per.status_code not in ('S','R')
6070: And pregen.element_type_id in
6071: ((select petr.element_type_id from pay_element_type_rules petr, psp_report_template_details_h prth where
6072: petr.include_or_exclude ='I'
6073: and prth.request_id =per.request_id and prth.criteria_lookup_code='EST'
6074: and petr.element_Set_id = prth.criteria_value1
6075: )

Line 6085: (select petr1.element_type_id from pay_element_type_rules petr1,

6081: and prth1.criteria_lookup_code='EST' and prth1.request_id =per.request_id
6082: and pecr.element_Set_id = prth1.criteria_value1
6083: ))
6084: And pregen.element_type_id not in
6085: (select petr1.element_type_id from pay_element_type_rules petr1,
6086: psp_report_template_Details_h prth2
6087: where petr1.include_or_exclude='E'
6088: and prth2.request_id = per.request_id
6089: and prth2.criteria_lookup_code='EST' and prth2.criteria_value1= petr1.element_Set_id