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.

[Home] [Help]

APPS.PSP_SUM_TRANS dependencies on PSP_REPORT_TEMPLATE_DETAILS

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 5724: psp_report_template_details_h prth1

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
5723: pay_element_types_f pet1, pay_ele_classification_rules pecr,
5724: psp_report_template_details_h prth1
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

Line 5730: psp_report_template_Details_h prth2

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 )
5734: group by per.person_id, per.effort_report_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 5758: psp_report_template_details_h prth1

5754: )
5755: union all
5756: (select pet1.element_type_id from
5757: pay_element_types_f pet1, pay_ele_classification_rules pecr,
5758: psp_report_template_details_h prth1
5759: where pet1.classification_id = pecr.classification_id and
5760: prth1.criteria_lookup_code='EST' and prth1.request_id =per.request_id and
5761: pecr.element_Set_id = prth1.criteria_value1
5762: ))

Line 5765: psp_report_template_Details_h prth2

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

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 5798: psp_report_template_details_h prth1

5794: )
5795: union all
5796: (select pet1.element_type_id from
5797: pay_element_types_f pet1, pay_ele_classification_rules pecr,
5798: psp_report_template_details_h prth1
5799: where pet1.classification_id = pecr.classification_id and
5800: prth1.criteria_lookup_code='EST' and prth1.request_id =per.request_id and
5801: pecr.element_Set_id = prth1.criteria_value1
5802: ))

Line 5805: psp_report_template_Details_h prth2

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

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 5842: psp_report_template_details_h prth1

5838: )
5839: union all
5840: (select pet1.element_type_id from
5841: pay_element_types_f pet1, pay_ele_classification_rules pecr,
5842: psp_report_template_details_h prth1
5843: where pet1.classification_id = pecr.classification_id and
5844: prth1.criteria_lookup_code='EST' and prth1.request_id =per.request_id
5845: and pecr.element_Set_id = prth1.criteria_value1
5846: ))

Line 5849: psp_report_template_Details_h prth2

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

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 5876: psp_report_template_details_h prth1

5872: )
5873: union all
5874: (select pet1.element_type_id from
5875: pay_element_types_f pet1, pay_ele_classification_rules pecr,
5876: psp_report_template_details_h prth1
5877: where pet1.classification_id = pecr.classification_id and
5878: prth1.criteria_lookup_code='EST' and prth1.request_id =per.request_id
5879: and pecr.element_Set_id = prth1.criteria_value1
5880: ))

Line 5883: psp_report_template_Details_h prth2

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

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 5914: psp_report_template_details_h prth1

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
5913: pay_element_types_f pet1, pay_ele_classification_rules pecr,
5914: psp_report_template_details_h prth1
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

Line 5920: psp_report_template_Details_h prth2

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 )
5924: group by per.person_id, per.effort_report_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 5951: psp_report_template_details_h prth1

5947: )
5948: union all
5949: (select pet1.element_type_id from
5950: pay_element_types_f pet1, pay_ele_classification_rules pecr,
5951: psp_report_template_details_h prth1
5952: where pet1.classification_id = pecr.classification_id and
5953: prth1.criteria_lookup_code='EST' and prth1.request_id =per.request_id
5954: and pecr.element_Set_id = prth1.criteria_value1
5955: ))

Line 5958: psp_report_template_Details_h prth2

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

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 5994: psp_report_template_details_h prth1

5990: )
5991: union all
5992: (select pet1.element_type_id from
5993: pay_element_types_f pet1, pay_ele_classification_rules pecr,
5994: psp_report_template_details_h prth1
5995: where pet1.classification_id = pecr.classification_id and
5996: prth1.criteria_lookup_code='EST' and prth1.request_id =per.request_id
5997: and pecr.element_Set_id = prth1.criteria_value1
5998: ))

Line 6001: psp_report_template_Details_h prth2

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

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 6042: psp_report_template_details_h prth1

6038: )
6039: union all
6040: (select pet1.element_type_id from
6041: pay_element_types_f pet1, pay_ele_classification_rules pecr,
6042: psp_report_template_details_h prth1
6043: where pet1.classification_id = pecr.classification_id
6044: and prth1.criteria_lookup_code='EST' and prth1.request_id =per.request_id
6045: and pecr.element_Set_id = prth1.criteria_value1
6046: ))

Line 6049: psp_report_template_Details_h prth2

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

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 6079: psp_report_template_details_h prth1

6075: )
6076: union all
6077: (select pet1.element_type_id from
6078: pay_element_types_f pet1, pay_ele_classification_rules pecr,
6079: psp_report_template_details_h prth1
6080: where pet1.classification_id = pecr.classification_id
6081: and prth1.criteria_lookup_code='EST' and prth1.request_id =per.request_id
6082: and pecr.element_Set_id = prth1.criteria_value1
6083: ))

Line 6086: psp_report_template_Details_h prth2

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

Line 6179: psp_report_template_details_h dtl

6175: select distinct wf.name,
6176: wf.orig_system_id
6177: from wf_roles wf,
6178: psp_report_templates_h h,
6179: psp_report_template_details_h dtl
6180: where wf.orig_system = 'PER'
6181: and to_char(wf.orig_system_id) = dtl.criteria_value1
6182: and dtl.criteria_lookup_type = 'PSP_SELECTION_CRITERIA'
6183: and dtl.criteria_lookup_code = 'FRP'

Line 6240: from psp_report_template_details

6236: p_approver_notify out nocopy boolean,
6237: p_employee_notify out nocopy boolean) is
6238: cursor get_notify_types is
6239: select criteria_lookup_code
6240: from psp_report_template_details
6241: where template_id = p_template_id
6242: and criteria_lookup_type = 'PSP_SUPERCEDED_NOTIFICATION';
6243:
6244: notify_type varchar2(10);