DBA Data[Home] [Help]

APPS.PER_COBRA_ECI dependencies on PAY_INPUT_VALUES

Line 943: pay_input_values_f iv_cov,

939: TRUNC(sysdate),
940: l_user_id,
941: l_login_id
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,

Line 944: pay_input_values_f iv_ee,

940: l_user_id,
941: l_login_id
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,

Line 945: pay_input_values_f iv_er,

941: l_login_id
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,

Line 1715: from pay_input_values_f iv_cov,

1711: l_user_id,
1712: TRUNC(sysdate),
1713: l_user_id,
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,

Line 1716: pay_input_values_f iv_ee,

1712: TRUNC(sysdate),
1713: l_user_id,
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,

Line 1717: pay_input_values_f iv_er,

1713: l_user_id,
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,

Line 2963: pay_input_values iv_cov,

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
2967: WHERE

Line 3004: pay_input_values iv_er,

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,
3008: pay_element_entries ee,

Line 3005: pay_input_values iv_ee,

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,
3008: pay_element_entries ee,
3009: pay_element_links el,

Line 3006: pay_input_values iv_cov,

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

Line 3061: pay_input_values iv_er,

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
3065: WHERE

Line 3062: pay_input_values iv_ee,

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
3065: WHERE
3066: bc.element_type_id(+) = et.element_type_id AND

Line 3063: pay_input_values iv_cov,

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
3065: WHERE
3066: bc.element_type_id(+) = et.element_type_id AND
3067: (