APPS.PER_PCL_BUS dependencies on BEN_ELIGY_PRFL_F

Line 1523: -- Validates that the eligy_prfl_id exists in ben_eligy_prfl_f. This

1519: -- ---------------------------------------------------------------------------
1520: --
1521: -- Desciption :
1522: --
1523: -- Validates that the eligy_prfl_id exists in ben_eligy_prfl_f. This
1524: -- procedure also ensures that the eligibility profile has only been
1525: -- used once for the entitlement.
1526: --
1527: -- Pre-conditions :

Line 1568: FROM ben_eligy_prfl_f bep

1564: -- Delcare Cursors
1565: --
1566: CURSOR csr_chk_id IS
1567: SELECT bep.eligy_prfl_id
1568: FROM ben_eligy_prfl_f bep
1569: WHERE business_group_id = p_business_group_id
1570: AND bep.eligy_prfl_id = p_eligy_prfl_id
1571: AND p_effective_date BETWEEN bep.effective_start_date AND bep.effective_end_date
1572: AND bep.bnft_cagr_prtn_cd IN ('GLOBAL','CAGR')

Line 1597: FROM ben_eligy_prfl_f bep

1593: -- pcl.effective_end_date);
1594: --
1595: CURSOR csr_chk_payscale IS
1596: SELECT bep.eligy_prfl_id
1597: FROM ben_eligy_prfl_f bep
1598: WHERE business_group_id = p_business_group_id
1599: AND bep.eligy_prfl_id = p_eligy_prfl_id
1600: AND p_effective_date BETWEEN bep.effective_start_date
1601: AND bep.effective_end_date