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.PER_PER_BUS1 dependencies on BEN_BENFTS_GRP

Line 982: -- - Validates that benefit_group_id exists in BEN_BENFTS_GRP where

978: -- ----------------------------------------------------------------------------
979: --
980: --
981: -- Description:
982: -- - Validates that benefit_group_id exists in BEN_BENFTS_GRP where
983: -- on the effective date.
984: --
985: -- Pre-conditions:
986: -- Valid p_person_id.

Line 996: -- - benefit_group_id = benfts_grp_id in the BEN_BENFTS_GRP on the

992: -- p_object_version_number
993: --
994: -- Post Success:
995: -- Processing continues if:
996: -- - benefit_group_id = benfts_grp_id in the BEN_BENFTS_GRP on the
997: -- effective date.
998: --
999: -- Post Failure:
1000: -- An application error is raised and processing is terminated if:

Line 1001: -- - Benefit group id doesn't exist in BEN_BENFTS_GRP on the

997: -- effective date.
998: --
999: -- Post Failure:
1000: -- An application error is raised and processing is terminated if:
1001: -- - Benefit group id doesn't exist in BEN_BENFTS_GRP on the
1002: -- effective date.
1003: --
1004: -- Access Status:
1005: -- Internal Table Handler Use Only.

Line 1017: from ben_benfts_grp

1013: is
1014: --
1015: cursor csr_chk_benefit_group_id is
1016: select null
1017: from ben_benfts_grp
1018: where benfts_grp_id = p_benefit_group_id;
1019: --
1020: l_proc varchar2(72) := g_package||'chk_benefit_group_id';
1021: l_benefit_group_id number;