DBA Data[Home] [Help]

APPS.PER_COBRA_ECI dependencies on PAY_ELEMENT_ENTRY_VALUES

Line 946: pay_element_entry_values_f eev_cov,

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,

Line 947: pay_element_entry_values_f eev_er,

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,

Line 948: pay_element_entry_values_f eev_ee,

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,

Line 1718: pay_element_entry_values_f eev_cov,

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,

Line 1719: pay_element_entry_values_f eev_er,

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,

Line 1720: pay_element_entry_values_f eev_ee,

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,

Line 2962: FROM pay_element_entry_values eev_cov,

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

Line 3001: pay_element_entry_values eev_er,

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,

Line 3002: pay_element_entry_values eev_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,

Line 3003: pay_element_entry_values eev_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,