[Home] [Help]
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
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
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
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
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
2961: ( SELECT 'x'
2962: FROM pay_element_entry_values eev_cov,
2963: pay_input_values iv_cov,
2964: pay_element_entries ee,
2965: pay_element_links el,
2966: pay_element_types et
2967: WHERE
2968: et.element_type_id = p_element_type_id
2969: AND
3005: pay_input_values iv_ee,
3006: pay_input_values iv_cov,
3007: ben_benefit_contributions bc,
3008: pay_element_entries ee,
3009: pay_element_links el,
3010: pay_element_types et
3011: WHERE
3012: bc.element_type_id(+) = et.element_type_id AND
3013: (