942: FROM
943: pay_input_values_f iv_cov,
944: pay_input_values_f iv_ee,
945: pay_input_values_f iv_er,
946: pay_element_entry_values_f eev_cov,
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,
943: pay_input_values_f iv_cov,
944: pay_input_values_f iv_ee,
945: pay_input_values_f iv_er,
946: pay_element_entry_values_f eev_cov,
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,
944: pay_input_values_f iv_ee,
945: pay_input_values_f iv_er,
946: pay_element_entry_values_f eev_cov,
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,
1714: l_login_id
1715: from pay_input_values_f iv_cov,
1716: pay_input_values_f iv_ee,
1717: pay_input_values_f iv_er,
1718: pay_element_entry_values_f eev_cov,
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,
1715: from pay_input_values_f iv_cov,
1716: pay_input_values_f iv_ee,
1717: pay_input_values_f iv_er,
1718: pay_element_entry_values_f eev_cov,
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,
1716: pay_input_values_f iv_ee,
1717: pay_input_values_f iv_er,
1718: pay_element_entry_values_f eev_cov,
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,
2958: SELECT 'Y'
2959: FROM dual
2960: WHERE EXISTS
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
2997: 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))) +
2998: 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)))
2999: ),'0')
3000: FROM
3001: pay_element_entry_values eev_er,
3002: pay_element_entry_values eev_ee,
3003: pay_element_entry_values eev_cov,
3004: pay_input_values iv_er,
3005: pay_input_values iv_ee,
2998: 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)))
2999: ),'0')
3000: FROM
3001: pay_element_entry_values eev_er,
3002: pay_element_entry_values eev_ee,
3003: pay_element_entry_values eev_cov,
3004: pay_input_values iv_er,
3005: pay_input_values iv_ee,
3006: pay_input_values iv_cov,
2999: ),'0')
3000: FROM
3001: pay_element_entry_values eev_er,
3002: pay_element_entry_values eev_ee,
3003: pay_element_entry_values eev_cov,
3004: pay_input_values iv_er,
3005: pay_input_values iv_ee,
3006: pay_input_values iv_cov,
3007: ben_benefit_contributions bc,