APPS.PSP_SUM_TRANS dependencies on PAY_ELEMENT_TYPES_F

Line 1902: pay_element_types_f pet,

1898: pet.element_name,
1899: hou.name
1900: from per_all_people_f ppf,
1901: per_all_assignments_f paf,
1902: pay_element_types_f pet,
1903: hr_all_organization_units hou
1904: where ppf.person_id = l_person_id
1905: and l_distribution_date between ppf.effective_start_date and ppf.effective_end_date
1906: and paf.assignment_id = l_assignment_id

Line 4243: pay_element_types_f pet,

4239: pet.element_name,
4240: hou.name
4241: from per_all_people_f ppf,
4242: per_all_assignments_f paf,
4243: pay_element_types_f pet,
4244: hr_all_organization_units hou
4245: where ppf.person_id = l_person_id
4246: and l_distribution_date between ppf.effective_start_date and ppf.effective_end_date
4247: and paf.assignment_id = l_assignment_id

Line 5300: pay_element_types_f pet1, pay_ele_classification_rules pecr,

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

Line 5334: pay_element_types_f pet1, pay_ele_classification_rules pecr,

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

Line 5374: pay_element_types_f pet1, pay_ele_classification_rules pecr,

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

Line 5418: pay_element_types_f pet1, pay_ele_classification_rules pecr,

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

Line 5452: pay_element_types_f pet1, pay_ele_classification_rules pecr,

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

Line 5490: pay_element_types_f pet1, pay_ele_classification_rules pecr,

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

Line 5527: pay_element_types_f pet1, pay_ele_classification_rules pecr,

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

Line 5570: pay_element_types_f pet1, pay_ele_classification_rules pecr,

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

Line 5618: pay_element_types_f pet1, pay_ele_classification_rules pecr,

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

Line 5655: pay_element_types_f pet1, pay_ele_classification_rules pecr,

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