APPS.GHR_PA_REQUESTS_PKG dependencies on PER_PERSON_TYPES

Line 1615: FROM per_person_types pet

1611: --
1612: --Bug# 6711759 Included the person type EX_EMP_APL
1613: CURSOR c_per_app IS
1614: SELECT 1
1615: FROM per_person_types pet
1616: ,per_people_f per
1617: WHERE nvl(p_effective_date,trunc(sysdate)) between per.effective_start_date and per.effective_end_date
1618: AND pet.person_type_id = per.person_type_id
1619: AND pet.system_person_type in ('APL','EX_EMP','EX_EMP_APL')

Line 1627: FROM per_person_types pet

1623: --
1624: -- Bug 4217510/ 4377361 added person type EMP_APL also
1625: CURSOR c_per_emp IS
1626: SELECT 1
1627: FROM per_person_types pet
1628: ,per_people_f per
1629: WHERE nvl(p_effective_date,trunc(sysdate)) between per.effective_start_date and per.effective_end_date
1630: AND pet.person_type_id = per.person_type_id
1631: AND (pet.system_person_type in ('EMP', 'EMP_APL')

Line 1670: FROM per_person_types pet

1666: l_ret_val VARCHAR2(5) := 'FALSE';
1667: --
1668: CURSOR c_per_app IS
1669: SELECT 1
1670: FROM per_person_types pet
1671: ,per_people_f per
1672: WHERE nvl(p_effective_date,trunc(sysdate)) between per.effective_start_date and per.effective_end_date
1673: AND pet.person_type_id = per.person_type_id
1674: AND pet.system_person_type in ('APL','EX_EMP')

Line 1682: FROM per_person_types pet

1678: --
1679: -- Bug 4217510/4377361 added person type EMP_APL also
1680: CURSOR c_per_emp IS
1681: SELECT 1
1682: FROM per_person_types pet
1683: ,per_people_f per
1684: WHERE nvl(p_effective_date,trunc(sysdate)) between per.effective_start_date and per.effective_end_date
1685: AND pet.person_type_id = per.person_type_id
1686: AND (pet.system_person_type in ('EMP', 'EMP_APL')