DBA Data[Home] [Help]

APPS.HRWSECI dependencies on PAY_INPUT_VALUES

Line 885: pay_input_values_f iv_cov,

881: TRUNC(sysdate),
882: l_user_id,
883: l_login_id
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,

Line 886: pay_input_values_f iv_ee,

882: l_user_id,
883: l_login_id
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,

Line 887: pay_input_values_f iv_er,

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

Line 2340: pay_input_values iv_cov,

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

Line 2381: pay_input_values iv_er,

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

Line 2382: pay_input_values iv_ee,

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,
2385: pay_element_entries ee,
2386: pay_element_links el,

Line 2383: pay_input_values iv_cov,

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,
2385: pay_element_entries ee,
2386: pay_element_links el,
2387: pay_element_types et

Line 2433: pay_input_values iv_er,

2429: NVL(fnd_number.canonical_to_number(bc.employee_contribution), DECODE(fnd_number.canonical_to_number(iv_cov.default_value), NULL, 0, fnd_number.canonical_to_number(iv_ee.default_value)))
2430: ),'0')
2431: FROM
2432: ben_benefit_contributions bc,
2433: pay_input_values iv_er,
2434: pay_input_values iv_ee,
2435: pay_input_values iv_cov,
2436: pay_element_types et
2437: WHERE

Line 2434: pay_input_values iv_ee,

2430: ),'0')
2431: FROM
2432: ben_benefit_contributions bc,
2433: pay_input_values iv_er,
2434: pay_input_values iv_ee,
2435: pay_input_values iv_cov,
2436: pay_element_types et
2437: WHERE
2438: bc.element_type_id(+) = et.element_type_id AND

Line 2435: pay_input_values iv_cov,

2431: FROM
2432: ben_benefit_contributions bc,
2433: pay_input_values iv_er,
2434: pay_input_values iv_ee,
2435: pay_input_values iv_cov,
2436: pay_element_types et
2437: WHERE
2438: bc.element_type_id(+) = et.element_type_id AND
2439: (