884: FROM
885: pay_input_values_f iv_cov,
886: pay_input_values_f iv_ee,
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,
885: pay_input_values_f iv_cov,
886: pay_input_values_f iv_ee,
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,
886: pay_input_values_f iv_ee,
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,
2335: SELECT 'Y'
2336: FROM dual
2337: WHERE EXISTS
2338: ( SELECT 'x'
2339: FROM pay_element_entry_values eev_cov,
2340: pay_input_values iv_cov,
2341: pay_element_entries ee,
2342: pay_element_links el,
2343: pay_element_types et
2374: NVL(fnd_number.canonical_to_number(eev_er.screen_entry_value), NVL(fnd_number.canonical_to_number(bc.employer_contribution), fnd_number.canonical_to_number(iv_er.default_value))) +
2375: NVL(fnd_number.canonical_to_number(eev_ee.screen_entry_value), NVL(fnd_number.canonical_to_number(bc.employee_contribution), fnd_number.canonical_to_number(iv_ee.default_value)))
2376: ),'0')
2377: FROM
2378: pay_element_entry_values eev_er,
2379: pay_element_entry_values eev_ee,
2380: pay_element_entry_values eev_cov,
2381: pay_input_values iv_er,
2382: pay_input_values iv_ee,
2375: NVL(fnd_number.canonical_to_number(eev_ee.screen_entry_value), NVL(fnd_number.canonical_to_number(bc.employee_contribution), fnd_number.canonical_to_number(iv_ee.default_value)))
2376: ),'0')
2377: FROM
2378: pay_element_entry_values eev_er,
2379: pay_element_entry_values eev_ee,
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,
2376: ),'0')
2377: FROM
2378: pay_element_entry_values eev_er,
2379: pay_element_entry_values eev_ee,
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,