APPS.PER_CTR_BUS dependencies on BEN_LER_F

Line 418: -- Validates that the start_life_reason_id exists in BEN_LER_F on the

414: -- |--------------------< chk_start_life_reason_id >-------------------------|
415: -- ---------------------------------------------------------------------
416: --
417: -- Description:
418: -- Validates that the start_life_reason_id exists in BEN_LER_F on the
419: -- effective_date.
420: --
421: -- Pre-Requisites:
422: -- None.

Line 449: from BEN_LER_F

445: p_effective_date in date,
446: p_object_version_number in number) is
447: cursor csr_chk_start_life_reason_id is
448: select ler_id
449: from BEN_LER_F
450: where p_start_life_reason_id = ler_id
451: and p_effective_date between effective_start_date and
452: effective_end_date;
453: --

Line 488: -- Validates that the end_life_reason_id exists in BEN_LER_F for a set

484: -- |--------------------< chk_end_life_reason_id >-------------------------|
485: -- ---------------------------------------------------------------------
486: --
487: -- Description:
488: -- Validates that the end_life_reason_id exists in BEN_LER_F for a set
489: -- effective_date.
490: --
491: -- Pre-Requisites:
492: -- None.

Line 502: -- Processing continues if the end_life_reason_id is valid in BEN_LER_F

498: -- p_object_version_number
499: --
500: --
501: -- Post Success:
502: -- Processing continues if the end_life_reason_id is valid in BEN_LER_F
503: -- on the set effective_date.
504: --
505: -- Post Failure:
506: -- An Application Error is raised and processing is terminated if

Line 520: from BEN_LER_F

516: ,p_object_version_number in number) is
517: --
518: cursor csr_chk_end_life_reason_id is
519: select ler_id
520: from BEN_LER_F
521: where p_end_life_reason_id = ler_id
522: and p_effective_date between effective_start_date and
523: effective_end_date;
524: --