APPS.PSP_SUM_TRANS dependencies on PAY_ELEMENT_TYPES_F

Line 2012: pay_element_types_f pet,

2008: pet.element_name,
2009: hou.name
2010: from per_all_people_f ppf,
2011: per_all_assignments_f paf,
2012: pay_element_types_f pet,
2013: hr_all_organization_units hou
2014: where ppf.person_id = l_person_id
2015: and l_distribution_date between ppf.effective_start_date and ppf.effective_end_date
2016: and paf.assignment_id = l_assignment_id

Line 4506: pay_element_types_f pet,

4502: pet.element_name,
4503: hou.name
4504: from per_all_people_f ppf,
4505: per_all_assignments_f paf,
4506: pay_element_types_f pet,
4507: hr_all_organization_units hou
4508: where ppf.person_id = l_person_id
4509: and l_distribution_date between ppf.effective_start_date and ppf.effective_end_date
4510: and paf.assignment_id = l_assignment_id

Line 5723: pay_element_types_f pet1, pay_ele_classification_rules pecr,

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

Line 5757: pay_element_types_f pet1, pay_ele_classification_rules pecr,

5753: petr.element_Set_id = prth.criteria_value1
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

Line 5797: pay_element_types_f pet1, pay_ele_classification_rules pecr,

5793: petr.element_Set_id = prth.criteria_value1
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

Line 5841: pay_element_types_f pet1, pay_ele_classification_rules pecr,

5837: petr.element_Set_id = prth.criteria_value1
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

Line 5875: pay_element_types_f pet1, pay_ele_classification_rules pecr,

5871: and petr.element_Set_id = prth.criteria_value1
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

Line 5913: pay_element_types_f pet1, pay_ele_classification_rules pecr,

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

Line 5950: pay_element_types_f pet1, pay_ele_classification_rules pecr,

5946: and petr.element_Set_id = prth.criteria_value1
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

Line 5993: pay_element_types_f pet1, pay_ele_classification_rules pecr,

5989: and petr.element_Set_id = prth.criteria_value1
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

Line 6041: pay_element_types_f pet1, pay_ele_classification_rules pecr,

6037: and petr.element_Set_id = prth.criteria_value1
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

Line 6078: pay_element_types_f pet1, pay_ele_classification_rules pecr,

6074: and petr.element_Set_id = prth.criteria_value1
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