APPS.PQH_LENGTH_OF_SERVICE_PKG dependencies on PER_ASSIGNMENT_EXTRA_INFO

Line 1567: FROM per_assignment_extra_info

1563: AND effective_end_date >= p_assg_start_date;
1564:
1565: CURSOR c_assg_los_type IS
1566: SELECT '1'
1567: FROM per_assignment_extra_info
1568: WHERE assignment_id = p_assignment_id
1569: AND nvl(aei_information1,'x') = p_los_type
1570: AND information_type = 'DE_PQH_ASSG_LOS_INFO';
1571:

Line 1696: FROM per_assignment_extra_info

1692: AND effective_end_date > p_assg_start_date;
1693:
1694: CURSOR c_assg_los_type IS
1695: SELECT '1'
1696: FROM per_assignment_extra_info
1697: WHERE assignment_id = p_assignment_id
1698: AND nvl(aei_information1,'x') = p_los_type
1699: AND information_type = 'DE_PQH_ASSG_LOS_INFO';
1700:

Line 1835: FROM per_assignment_extra_info

1831: AND pos.business_group_id = wkvr.business_group_id;
1832:
1833: CURSOR c_assg_los_type IS
1834: SELECT '1'
1835: FROM per_assignment_extra_info
1836: WHERE assignment_id = p_assignment_id
1837: AND nvl(aei_information1,'x') = p_los_type
1838: AND information_type = 'DE_PQH_ASSG_LOS_INFO';
1839:

Line 2032: FROM per_assignment_extra_info

2028: AND trunc(sysdate) between effective_start_date and effective_end_date;
2029:
2030: CURSOR c_assg_los_type IS
2031: SELECT '1'
2032: FROM per_assignment_extra_info
2033: WHERE assignment_id = p_assignment_id
2034: AND nvl(aei_information1,'x') = p_los_type
2035: AND information_type = 'DE_PQH_ASSG_LOS_INFO';
2036:

Line 2159: FROM per_assignment_extra_info

2155: AND p_assg_end_date BETWEEN spp.effective_start_date and spp.effective_end_date;
2156:
2157: CURSOR c_assg_los_type IS
2158: SELECT '1'
2159: FROM per_assignment_extra_info
2160: WHERE assignment_id = p_assignment_id
2161: AND nvl(aei_information1,'x') = p_los_type
2162: AND information_type = 'DE_PQH_ASSG_LOS_INFO';
2163:

Line 2282: FROM per_assignment_extra_info

2278: l_proc varchar2(60) := g_package||'get_de_assg_LOS';
2279:
2280: CURSOR c_assg_los_type IS
2281: SELECT '1'
2282: FROM per_assignment_extra_info
2283: WHERE assignment_id = p_assignment_id
2284: AND nvl(aei_information1,'x') = p_los_type
2285: AND information_type = 'DE_PQH_ASSG_LOS_INFO';
2286: