APPS.PQH_SS_PRINT dependencies on HR_LEG_LOOKUPS

Line 466: from hr_leg_lookups

462: l_meaning hr_lookups.meaning%type :=null;
463:
464: Cursor get_award_meaning IS
465: select meaning
466: from hr_leg_lookups
467: where lookup_type = 'PER_SUBJECT_STATUSES' and
468: lookup_code = p_award_id and
469: g_effective_date between nvl(start_date_active, g_effective_date)
470: and nvl(end_date_active, g_effective_date) and enabled_flag = 'Y'

Line 493: hr_leg_lookups

489: Cursor cur_get_tuition_meaning is
490: SELECT
491: meaning
492: FROM
493: hr_leg_lookups
494: WHERE
495: lookup_type = 'PER_TUITION_METHODS'
496: AND lookup_code = p_tuition_id
497: AND g_effective_date BETWEEN NVL(start_date_active, g_effective_date)

Line 501: l_meaning hr_leg_lookups.meaning%type := null;

497: AND g_effective_date BETWEEN NVL(start_date_active, g_effective_date)
498: AND NVL(end_date_active, g_effective_date)
499: AND enabled_flag = 'Y';
500:
501: l_meaning hr_leg_lookups.meaning%type := null;
502: BEGIN
503:
504: OPEN cur_get_tuition_meaning;
505: FETCH cur_get_tuition_meaning into l_meaning;

Line 618: FROM hr_leg_lookups

614: FUNCTION get_termination_reason (p_termination_code varchar2) RETURN VARCHAR2
615: IS
616: CURSOR csr_reason IS
617: SELECT meaning
618: FROM hr_leg_lookups
619: WHERE lookup_type = 'LEAV_REAS'
620: AND lookup_code = p_termination_code
621: AND enabled_flag = 'Y';
622:

Line 645: from hr_leg_lookups hl

641: IS
642:
643: CURSOR csr_frequency IS
644: select hl.meaning
645: from hr_leg_lookups hl
646: where hl.lookup_type = 'FREQUENCY'
647: and hl.lookup_code = p_freq_code
648: and hl.enabled_flag = 'Y'
649: and trunc(g_effective_date) BETWEEN nvl(hl.start_date_active, trunc(g_effective_date))

Line 671: from hr_leg_lookups hl

667: IS
668:
669: CURSOR csr_category IS
670: select hl.meaning
671: from hr_leg_lookups hl
672: where hl.lookup_type = 'EMPLOYEE_CATG'
673: and hl.lookup_code = p_category_code
674: and hl.enabled_flag = 'Y'
675: and trunc(g_effective_date) between nvl(start_date_active, trunc(g_effective_date))

Line 694: from hr_leg_lookups hl

690: IS
691:
692: CURSOR csr_category IS
693: select hl.meaning
694: from hr_leg_lookups hl
695: where hl.lookup_type = 'EMP_CAT'
696: and hl.lookup_code = p_category_code
697: and hl.enabled_flag = 'Y'
698: and trunc(g_effective_date) between nvl(start_date_active, trunc(g_effective_date))

Line 933: from hr_leg_lookups

929: FUNCTION get_change_reason(p_reason_code IN VARCHAR2) RETURN VARCHAR2
930: IS
931: CURSOR csr_change_reason IS
932: select meaning
933: from hr_leg_lookups
934: where lookup_type = 'EMP_ASSIGN_REASON'
935: and enabled_flag = 'Y'
936: AND trunc(g_effective_date) BETWEEN NVL(start_date_active, trunc(g_effective_date))
937: AND NVL(end_date_active, trunc(g_effective_date))

Line 941: from hr_leg_lookups

937: AND NVL(end_date_active, trunc(g_effective_date))
938: and lookup_code =p_reason_code
939: UNION
940: select meaning
941: from hr_leg_lookups
942: where lookup_type = 'CWK_ASSIGN_REASON'
943: and enabled_flag = 'Y'
944: AND trunc(g_effective_date) BETWEEN NVL(start_date_active,
945: trunc(g_effective_date))