APPS.PER_PERSON_TYPES_PKG dependencies on HR_LOOKUPS

Line 56: from hr_lookups lu, per_person_types pt

52: -- to avoid FTS
53: -- Bug #3646157
54: --
55: cursor csr_system_name is select null
56: from hr_lookups lu, per_person_types pt
57: where pt.business_group_id = p_business_group_id
58: and lu.meaning = p_system_name
59: and lu.lookup_type = 'PERSON_TYPE'
60: and lu.lookup_code = pt.system_person_type

Line 404: from hr_lookups hr

400: -- Suppression of BG index(+ 0) is removed
401: -- to avoid FTS
402: -- Bug #3646157
403: CURSOR C IS SELECT hr.meaning
404: from hr_lookups hr
405: WHERE hr.lookup_type = 'PERSON_TYPE'
406: and not exists
407: (select null
408: from per_person_types ppt

Line 433: l_system_name_nodefault hr_lookups.meaning%TYPE;

429: END Check_Delete;
430:
431: PROCEDURE Check_Default (X_Business_Group_Id IN NUMBER) IS
432: --
433: l_system_name_nodefault hr_lookups.meaning%TYPE;
434: l_system_name_default hr_lookups.meaning%TYPE;
435: --
436: -- Cursor to pull back all of the System Names that don't have a default
437: -- Person Type record.

Line 434: l_system_name_default hr_lookups.meaning%TYPE;

430:
431: PROCEDURE Check_Default (X_Business_Group_Id IN NUMBER) IS
432: --
433: l_system_name_nodefault hr_lookups.meaning%TYPE;
434: l_system_name_default hr_lookups.meaning%TYPE;
435: --
436: -- Cursor to pull back all of the System Names that don't have a default
437: -- Person Type record.
438: --

Line 445: FROM hr_lookups hr

441: -- Bug #3646157
442: --
443: CURSOR csr_nodefault IS
444: SELECT hr.meaning
445: FROM hr_lookups hr
446: WHERE hr.lookup_type = 'PERSON_TYPE'
447: AND EXISTS
448: (SELECT null
449: FROM per_person_types ppt

Line 465: FROM hr_lookups hr

461: -- Bug #3646157
462: --
463: CURSOR csr_default IS
464: SELECT hr.meaning
465: FROM hr_lookups hr
466: WHERE hr.lookup_type = 'PERSON_TYPE'
467: AND EXISTS
468: (SELECT null
469: FROM per_person_types ppt