APPS.PO_REQAPPROVAL_FINDAPPRV1 dependencies on PER_PERSON_TYPES_V

Line 1729: Introduced view PER_PERSON_TYPES_V

1725: ** SQLs to improve performance.
1726: ** Also added CWK assignment type
1727: */
1728: /*Bug 8331565:
1729: Introduced view PER_PERSON_TYPES_V
1730: to get if the next approver is Contingent worker
1731: */
1732: CURSOR c1 (p_empid NUMBER, p_business_group_id NUMBER) IS
1733: SELECT pafe.supervisor_id

Line 1737: per_person_types_v ppts,

1733: SELECT pafe.supervisor_id
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

Line 1765: Introduced view PER_PERSON_TYPES_V

1761: ** SQLs to improve performance.
1762: ** Also added CWK assignment type
1763: */
1764: /*Bug 8331565:
1765: Introduced view PER_PERSON_TYPES_V
1766: to get if the next approver is Contingent worker
1767: */
1768: CURSOR C2 ( p_empid NUMBER ) IS
1769: SELECT DISTINCT Pafe.supervisor_id

Line 1773: per_person_types_v ppts,

1769: SELECT DISTINCT Pafe.supervisor_id
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