[Home] [Help]
887: pay_input_values_f iv_er,
888: pay_element_entry_values_f eev_cov,
889: pay_element_entry_values_f eev_er,
890: pay_element_entry_values_f eev_ee,
891: ben_benefit_contributions_f bc,
892: ben_benefit_classifications bc2,
893: pay_element_types_f et,
894: pay_element_links_f el,
895: pay_element_entries_f ee
2098: --
2099: CURSOR coverage_amount IS
2100: SELECT bc.employer_contribution + bc.employee_contribution,
2101: bc.employer_contribution + bc.employee_contribution
2102: FROM ben_benefit_contributions bc
2103: WHERE bc.business_group_id + 0 = p_business_group_id
2104: AND bc.coverage_type = p_coverage_type
2105: AND bc.element_type_id = p_element_type_id
2106: AND p_session_date BETWEEN
2360: -- chk_bc_exists - tests whether ben cont exists for given element and coverage
2361: --
2362: CURSOR chk_bc_exists IS
2363: SELECT 'Y'
2364: FROM ben_benefit_contributions
2365: WHERE
2366: element_type_id = p_element_type_id AND
2367: coverage_type = p_coverage_type;
2368: --
2380: pay_element_entry_values eev_cov,
2381: pay_input_values iv_er,
2382: pay_input_values iv_ee,
2383: pay_input_values iv_cov,
2384: ben_benefit_contributions bc,
2385: pay_element_entries ee,
2386: pay_element_links el,
2387: pay_element_types et
2388: WHERE
2428: NVL(fnd_number.canonical_to_number(bc.employer_contribution), DECODE(fnd_number.canonical_to_number(iv_cov.default_value), NULL, 0, fnd_number.canonical_to_number(iv_er.default_value))) +
2429: NVL(fnd_number.canonical_to_number(bc.employee_contribution), DECODE(fnd_number.canonical_to_number(iv_cov.default_value), NULL, 0, fnd_number.canonical_to_number(iv_ee.default_value)))
2430: ),'0')
2431: FROM
2432: ben_benefit_contributions bc,
2433: pay_input_values iv_er,
2434: pay_input_values iv_ee,
2435: pay_input_values iv_cov,
2436: pay_element_types et