DBA Data[Home] [Help]

APPS.HRWSECI dependencies on PAY_ELEMENT_ENTRIES

Line 360: pay_element_entries_f ee

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
363: l_last_eligible_date BETWEEN
364: ee.effective_start_date AND ee.effective_end_date

Line 895: pay_element_entries_f 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
898: l_last_eligible_date
899: BETWEEN ee.effective_start_date AND ee.effective_end_Date

Line 2341: pay_element_entries ee,

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
2345: et.element_type_id = p_element_type_id

Line 2385: pay_element_entries ee,

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