APPS.PER_COBRA_ECI dependencies on PAY_ELEMENT_ENTRIES_F

Line 403: pay_element_entries_f ee

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
407: ee.effective_start_date AND ee.effective_end_date

Line 953: pay_element_entries_f 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
957: BETWEEN ee.effective_start_date AND ee.effective_end_Date

Line 1560: ,pay_element_entries_f ee

1556: ,ccb.element_type_id
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

Line 1579: from pay_element_entries_f ee

1575: cursor csr_available_element_entry is
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

Line 1725: pay_element_entries_f 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
1729: et.element_type_id = l_element_type_id