DBA Data[Home] [Help]

APPS.PO_REQAPPROVAL_FINDAPPRV1 dependencies on PER_PERSON_TYPE_USAGES_F

Line 1738: per_person_type_usages_f pptu

1734: FROM Per_All_Assignments_f pafe, --
1735: Per_All_People_f ppfs, --
1736: Per_All_Assignments_f pafs, --
1737: per_person_types_v ppts,
1738: per_person_type_usages_f pptu
1739: WHERE pafe.business_group_id = p_business_group_id
1740: AND pafe.person_id = p_empid
1741: AND Trunc(SYSDATE) BETWEEN pafe.Effective_Start_Date
1742: AND pafe.Effective_End_Date

Line 1774: per_person_type_usages_f pptu

1770: FROM Per_All_Assignments_f pafe, --
1771: Per_All_People_f ppfs, --
1772: Per_All_Assignments_f pafs, --
1773: per_person_types_v ppts,
1774: per_person_type_usages_f pptu
1775: WHERE pafe.person_id = p_empid
1776: AND Trunc(SYSDATE) BETWEEN pafe.Effective_Start_Date
1777: AND pafe.Effective_End_Date
1778: AND pafe.Primary_Flag = 'Y'