APPS.PER_COBRA_ECI dependencies on BEN_BENEFIT_CLASSIFICATIONS

Line 400: ben_benefit_classifications bc,

396: --
397: CURSOR get_cobra_benefits IS
398: SELECT 'Y'
399: FROM
400: ben_benefit_classifications bc,
401: pay_element_types et,
402: pay_element_links_f el,
403: pay_element_entries_f ee
404: WHERE

Line 950: ben_benefit_classifications bc2,

946: pay_element_entry_values_f eev_cov,
947: pay_element_entry_values_f eev_er,
948: pay_element_entry_values_f eev_ee,
949: ben_benefit_contributions_f bc,
950: ben_benefit_classifications bc2,
951: pay_element_types_f et,
952: pay_element_links_f el,
953: pay_element_entries_f ee
954: WHERE

Line 1583: ,ben_benefit_classifications bc

1579: from pay_element_entries_f ee
1580: ,pay_element_links_f el
1581: ,pay_element_types_f et
1582: ,pay_element_classifications ec
1583: ,ben_benefit_classifications bc
1584: where ee.assignment_id = p_assignment_id
1585: and p_effective_date between ee.effective_start_date
1586: and ee.effective_end_date
1587: and el.element_link_id = ee.element_link_id

Line 1722: ben_benefit_classifications bc2,

1718: pay_element_entry_values_f eev_cov,
1719: pay_element_entry_values_f eev_er,
1720: pay_element_entry_values_f eev_ee,
1721: ben_benefit_contributions_f bc,
1722: ben_benefit_classifications bc2,
1723: pay_element_types_f et,
1724: pay_element_links_f el,
1725: pay_element_entries_f ee
1726: WHERE