eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQH_SS_PRINT dependencies on HR_LOOKUPS

Line 284: Select Meaning from hr_lookups

280: --
281: FUNCTION decode_value(p_lookup_code varchar2) RETURN VARCHAR2
282: IS
283: CURSOR csr_meaning IS
284: Select Meaning from hr_lookups
285: where lookup_type ='PQH_CURRENT_PROPOSED'
286: AND enabled_flag = 'Y'
287: AND lookup_code = p_lookup_code;
288:

Line 289: l_meaning hr_lookups.meaning%type := null;

285: where lookup_type ='PQH_CURRENT_PROPOSED'
286: AND enabled_flag = 'Y'
287: AND lookup_code = p_lookup_code;
288:
289: l_meaning hr_lookups.meaning%type := null;
290:
291: BEGIN
292:
293: OPEN csr_meaning;

Line 434: l_meaning hr_lookups.meaning%type :=null;

430: --
431: --
432: FUNCTION get_tenure_status (p_lookup_code varchar2) RETURN VARCHAR2 IS
433:
434: l_meaning hr_lookups.meaning%type :=null;
435: BEGIN
436:
437: SELECT hr_general.decode_lookup('PQH_TENURE_STATUS',p_lookup_code) into l_meaning
438: FROM DUAL;

Line 462: l_meaning hr_lookups.meaning%type :=null;

458: --
459: --
460: FUNCTION get_award_status (p_award_id varchar2) RETURN VARCHAR2 IS
461:
462: l_meaning hr_lookups.meaning%type :=null;
463:
464: Cursor get_award_meaning IS
465: select meaning
466: from hr_leg_lookups

Line 545: from hr_lookups hl

541: FUNCTION get_person_title(p_title_code varchar2) RETURN VARCHAR2 IS
542:
543: cursor csr_get_title IS
544: select hl.meaning
545: from hr_lookups hl
546: where hl.lookup_type = 'TITLE'
547: and hl.lookup_code = p_title_code
548: and hl.enabled_flag = 'Y'
549: and trunc(g_effective_date) between trunc(nvl(hl.start_date_active,g_effective_date))

Line 552: l_meaning hr_lookups.meaning%type := null;

548: and hl.enabled_flag = 'Y'
549: and trunc(g_effective_date) between trunc(nvl(hl.start_date_active,g_effective_date))
550: and trunc(nvl(hl.end_date_active,g_effective_date));
551:
552: l_meaning hr_lookups.meaning%type := null;
553:
554: BEGIN
555:
556: OPEN csr_get_title;

Line 569: from hr_lookups hrl where

565: FUNCTION get_gender (p_gender_code varchar2) RETURN VARCHAR2 IS
566:
567: CURSOR csr_gender IS
568: select hrl.meaning
569: from hr_lookups hrl where
570: hrl.lookup_type = 'SEX' and
571: hrl.Lookup_Code = p_gender_code and
572: hrl.enabled_flag = 'Y' and
573: trunc(SYSDATE) between trunc(nvl(hrl.start_date_active,SYSDATE))

Line 576: l_meaning hr_lookups.meaning%type := null;

572: hrl.enabled_flag = 'Y' and
573: trunc(SYSDATE) between trunc(nvl(hrl.start_date_active,SYSDATE))
574: and trunc(nvl(hrl.end_date_active,SYSDATE));
575:
576: l_meaning hr_lookups.meaning%type := null;
577:
578: BEGIN
579:
580: OPEN csr_gender;

Line 594: from hr_lookups hl

590: FUNCTION get_marital_status (p_marital_code varchar2) RETURN VARCHAR2 IS
591:
592: CURSOR csr_marital_status IS
593: select hl.meaning
594: from hr_lookups hl
595: where hl.lookup_type = 'MAR_STATUS'
596: and hl.lookup_code = p_marital_code
597: and hl.enabled_flag = 'Y'
598: and g_effective_date between nvl(start_date_active, g_effective_date - 1)

Line 601: l_meaning hr_lookups.meaning%type := null;

597: and hl.enabled_flag = 'Y'
598: and g_effective_date between nvl(start_date_active, g_effective_date - 1)
599: and nvl(end_date_active, g_effective_date);
600:
601: l_meaning hr_lookups.meaning%type := null;
602:
603: BEGIN
604:
605: OPEN csr_marital_status;

Line 623: l_meaning hr_lookups.meaning%type := null;

619: WHERE lookup_type = 'LEAV_REAS'
620: AND lookup_code = p_termination_code
621: AND enabled_flag = 'Y';
622:
623: l_meaning hr_lookups.meaning%type := null;
624:
625: BEGIN
626:
627:

Line 652: l_meaning hr_lookups.meaning%type := null;

648: and hl.enabled_flag = 'Y'
649: and trunc(g_effective_date) BETWEEN nvl(hl.start_date_active, trunc(g_effective_date))
650: AND nvl(hl.end_date_active, trunc(g_effective_date));
651:
652: l_meaning hr_lookups.meaning%type := null;
653: BEGIN
654:
655: OPEN csr_frequency ;
656:

Line 677: l_meaning hr_lookups.meaning%type := null;

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))
676: and nvl(end_date_active, trunc(g_effective_date));
677: l_meaning hr_lookups.meaning%type := null;
678: BEGIN
679:
680: OPEN csr_category;
681: FETCH csr_category into l_meaning;

Line 700: l_meaning hr_lookups.meaning%type := null;

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))
699: and nvl(end_date_active, trunc(g_effective_date));
700: l_meaning hr_lookups.meaning%type := null;
701: BEGIN
702:
703: OPEN csr_category;
704: FETCH csr_category into l_meaning;

Line 715: Select Meaning from hr_lookups

711: --
712: FUNCTION get_yes_no (p_lookup_code varchar2) RETURN VARCHAR2
713: IS
714: CURSOR csr_meaning IS
715: Select Meaning from hr_lookups
716: where lookup_type ='YES_NO'
717: AND enabled_flag = 'Y'
718: AND lookup_code = p_lookup_code;
719:

Line 720: l_meaning hr_lookups.meaning%type := null;

716: where lookup_type ='YES_NO'
717: AND enabled_flag = 'Y'
718: AND lookup_code = p_lookup_code;
719:
720: l_meaning hr_lookups.meaning%type := null;
721:
722: BEGIN
723:
724: OPEN csr_meaning;

Line 744: l_meaning hr_lookups.meaning%type := null;

740: FROM
741: PER_ESTABLISHMENTS
742: Where ESTABLISHMENT_ID = p_establishment_id;
743:
744: l_meaning hr_lookups.meaning%type := null;
745:
746: BEGIN
747:
748: OPEN csr_establishment;