DBA Data[Home] [Help]

APPS.HR_SE_VALIDATE_PKG dependencies on HR_LOOKUPS

Line 616: FROM hr_lookups

612:
613: CURSOR csr_agreement_meaning(csr_v_lookup_code varchar2) is
614: SELECT
615: trim(meaning)
616: FROM hr_lookups
617: WHERE lookup_type='SE_AGREEMENT_CODE'
618: AND lookup_code=TRIM(csr_v_lookup_code);
619:
620:

Line 1489: FROM hr_lookups

1485:
1486: CURSOR csr_agreement_meaning(csr_v_lookup_code varchar2) is
1487: SELECT
1488: trim(meaning)
1489: FROM hr_lookups
1490: WHERE lookup_type='SE_AGREEMENT_CODE'
1491: AND lookup_code=TRIM(csr_v_lookup_code);
1492:
1493: l_global_value NUMBER;