APPS.PER_COBRA_ECI dependencies on PAY_ELEMENT_LINKS_F

Line 402: pay_element_links_f el,

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
405: ee.assignment_id = p_assignment_id AND
406: l_last_eligible_date BETWEEN

Line 952: pay_element_links_f el,

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
955: ee.assignment_id = p_assignment_id AND
956: l_last_eligible_date

Line 1561: ,pay_element_links_f el

1557: ,ccb.cobra_coverage_benefit_id
1558: ,ccb.effective_start_date
1559: from per_cobra_coverage_benefits_f ccb
1560: ,pay_element_entries_f ee
1561: ,pay_element_links_f el
1562: where ccb.cobra_coverage_enrollment_id = p_cobra_coverage_enrollment_id
1563: and p_effective_date between ccb.effective_start_date
1564: and ccb.effective_end_date
1565: and ccb.element_type_id = el.element_type_id

Line 1580: ,pay_element_links_f el

1576: select et.element_type_id
1577: ,ee.effective_start_date
1578: ,ee.effective_end_date
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

Line 1724: pay_element_links_f el,

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
1727: ee.assignment_id = p_assignment_id
1728: AND