APPS.PER_BPD_BUS dependencies on HR_LOOKUPS

Line 506: -- If the CHECK_TYPE is not null, check that it is contained in HR_LOOKUPS

502: -- ----------------------------------------------------------------------------
503: -- {Start Of Comments}
504: --
505: -- Description:
506: -- If the CHECK_TYPE is not null, check that it is contained in HR_LOOKUPS
507: -- Pre Conditions:
508: --
509: -- In Arguments:
510: -- p_payment_detail_id

Line 531: FROM hr_lookups

527: IS
528: --
529: CURSOR csr_check_type IS
530: SELECT start_date_active, end_date_active
531: FROM hr_lookups
532: WHERE lookup_type = 'BACKFEED_PD_CHECK_TYPE'
533: AND lookup_code = p_check_type;
534: --
535: l_start_date DATE;

Line 557: -- The lookup code entered doesn't exist in hr_lookups

553: FETCH csr_check_type INTO l_start_date, l_end_date;
554: --
555: IF csr_check_type%NOTFOUND THEN
556: --
557: -- The lookup code entered doesn't exist in hr_lookups
558: -- so error.
559: --
560: hr_utility.set_message(800, 'HR_52949_CT_NOT_EXIST');
561: hr_utility.raise_error;