APPS.PER_COBRA_ECI dependencies on BEN_BENEFIT_CONTRIBUTIONS

Line 949: ben_benefit_contributions_f bc,

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,
953: pay_element_entries_f ee

Line 1721: ben_benefit_contributions_f bc,

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,
1725: pay_element_entries_f ee

Line 2723: FROM ben_benefit_contributions bc

2719: --
2720: CURSOR coverage_amount IS
2721: SELECT bc.employer_contribution + bc.employee_contribution,
2722: bc.employer_contribution + bc.employee_contribution
2723: FROM ben_benefit_contributions bc
2724: WHERE bc.business_group_id + 0 = p_business_group_id
2725: AND bc.coverage_type = p_coverage_type
2726: AND bc.element_type_id = p_element_type_id
2727: AND p_session_date BETWEEN

Line 2987: FROM ben_benefit_contributions

2983: -- chk_bc_exists - tests whether ben cont exists for given element and coverage
2984: --
2985: CURSOR chk_bc_exists IS
2986: SELECT 'Y'
2987: FROM ben_benefit_contributions
2988: WHERE
2989: element_type_id = p_element_type_id AND
2990: coverage_type = p_coverage_type;
2991: --

Line 3007: ben_benefit_contributions bc,

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,
3008: pay_element_entries ee,
3009: pay_element_links el,
3010: pay_element_types et
3011: WHERE

Line 3060: ben_benefit_contributions bc,

3056: NVL(fnd_number.canonical_to_number(bc.employer_contribution), DECODE(iv_cov.default_value, NULL, 0, fnd_number.canonical_to_number(iv_er.default_value))) +
3057: NVL(fnd_number.canonical_to_number(bc.employee_contribution), DECODE(iv_cov.default_value, NULL, 0, fnd_number.canonical_to_number(iv_ee.default_value)))
3058: ),'0') --Fix 8646350
3059: FROM
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