APPS.HXC_TIMEKEEPER_UTILITIES dependencies on PER_PERSON_TYPES

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

3115: /*ADVICE(2568): NUMBER has no precision [315] */
3116: ;
3117: m_alias_lovcoltype VARCHAR2 (10);
3118: /*Start fix for Bug 5055770 */
3119: l_person_type PER_PERSON_TYPES.SYSTEM_PERSON_TYPE%TYPE:=NULL;
3120: /*End fix for Bug 5055770 */
3121: /*ADVICE(2572): Initialization to NULL is superfluous [417] */
3122:
3123:

Line 3128: FROM per_person_types typ, per_person_type_usages_f ptu

3124: CURSOR c_get_type (
3125: p_person_id NUMBER
3126: ) IS
3127: SELECT typ.system_person_type
3128: FROM per_person_types typ, per_person_type_usages_f ptu
3129: WHERE typ.person_type_id = ptu.person_type_id
3130: AND SYSDATE BETWEEN ptu.effective_start_date AND ptu.effective_end_date
3131: AND ptu.person_id = p_person_id;
3132: BEGIN