DBA Data[Home] [Help]

APPS.HRWSECI dependencies on PAY_ELEMENT_TYPES

Line 358: pay_element_types et,

354: CURSOR get_cobra_benefits IS
355: SELECT 'Y'
356: FROM
357: ben_benefit_classifications bc,
358: pay_element_types et,
359: pay_element_links_f el,
360: pay_element_entries_f ee
361: WHERE
362: ee.assignment_id = p_assignment_id AND

Line 893: pay_element_types_f et,

889: pay_element_entry_values_f eev_er,
890: pay_element_entry_values_f eev_ee,
891: ben_benefit_contributions_f bc,
892: ben_benefit_classifications bc2,
893: pay_element_types_f et,
894: pay_element_links_f el,
895: pay_element_entries_f ee
896: WHERE
897: ee.assignment_id = p_assignment_id AND

Line 2343: pay_element_types et

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
2345: et.element_type_id = p_element_type_id
2346: AND
2347: el.element_type_id = et.element_type_id

Line 2387: pay_element_types et

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
2388: WHERE
2389: bc.element_type_id(+) = et.element_type_id AND
2390: (
2391: (bc.coverage_type IS NULL)

Line 2436: pay_element_types et

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: (
2440: (bc.coverage_type IS NULL)