APPS.HXC_TIMEKEEPER_UTILITIES dependencies on PER_PERSON_TYPES

Line 3101: l_person_type PER_PERSON_TYPES.SYSTEM_PERSON_TYPE%TYPE:=NULL;

3097: /*ADVICE(2568): NUMBER has no precision [315] */
3098: ;
3099: m_alias_lovcoltype VARCHAR2 (10);
3100: /*Start fix for Bug 5055770 */
3101: l_person_type PER_PERSON_TYPES.SYSTEM_PERSON_TYPE%TYPE:=NULL;
3102: /*End fix for Bug 5055770 */
3103: /*ADVICE(2572): Initialization to NULL is superfluous [417] */
3104:
3105:

Line 3110: FROM per_person_types typ, per_person_type_usages_f ptu

3106: CURSOR c_get_type (
3107: p_person_id NUMBER
3108: ) IS
3109: SELECT typ.system_person_type
3110: FROM per_person_types typ, per_person_type_usages_f ptu
3111: WHERE typ.person_type_id = ptu.person_type_id
3112: AND SYSDATE BETWEEN ptu.effective_start_date AND ptu.effective_end_date
3113: AND ptu.person_id = p_person_id;
3114: BEGIN