[Home] [Help]
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
405: ee.assignment_id = p_assignment_id AND
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
955: ee.assignment_id = p_assignment_id AND
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
1585: and p_effective_date between ee.effective_start_date
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
1727: ee.assignment_id = p_assignment_id
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
2970: el.element_type_id = et.element_type_id
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: (
3014: (bc.coverage_type IS NULL)
3060: ben_benefit_contributions bc,
3061: pay_input_values iv_er,
3062: pay_input_values iv_ee,
3063: pay_input_values iv_cov,
3064: pay_element_types et
3065: WHERE
3066: bc.element_type_id(+) = et.element_type_id AND
3067: (
3068: (bc.coverage_type IS NULL)