APPS.HR_AU_HOLIDAYS dependencies on PAY_ELEMENT_ENTRIES_F

Line 209: pay_element_entries_f pee,

205: peev.screen_entry_value accrued,
206: (to_date(peev1.screen_entry_value, 'YYYY/MM/DD HH24:MI:SS')) start_date,
207: (to_date(peev2.screen_entry_value, 'YYYY/MM/DD HH24:MI:SS')) end_date
208: from
209: pay_element_entries_f pee,
210: pay_element_entry_values_f peev,
211: pay_element_entry_values_f peev1,
212: pay_element_entry_values_f peev2,
213: pay_element_types_f pet,

Line 223: and pee.effective_start_date = (select Max(pe.effective_start_date) from pay_element_entries_f pe , pay_element_entry_values_f peev,

219: and pet.element_name IN ('Statutory Paid Parental Leave Payment', 'Rec Statutory PPL Payment')
220: and pet.legislation_code = 'AU'
221: and peev.screen_entry_value = 'N'
222: and pee.element_entry_id = peev.element_entry_id
223: and pee.effective_start_date = (select Max(pe.effective_start_date) from pay_element_entries_f pe , pay_element_entry_values_f peev,
224: pay_input_values_f piv
225: where pe.assignment_id = p_assignment_id
226: and pee.element_entry_id= pe.element_entry_id
227: and peev.screen_entry_value = 'N'

Line 1198: pay_element_entries_f pee,

1194: ,p_effective_date DATE
1195: ,p_plan_category VARCHAR2) IS
1196: SELECT pap.accrual_plan_id
1197: FROM pay_accrual_plans pap,
1198: pay_element_entries_f pee,
1199: pay_element_links_f pel,
1200: pay_element_types_f pet
1201: WHERE pee.assignment_id = p_assignment_id
1202: AND p_effective_date BETWEEN pee.effective_start_date AND pee.effective_end_date

Line 1766: pay_element_entries_f pee,

1762: ,c_calculation_date IN DATE
1763: ,c_assignment_id IN NUMBER) IS
1764: SELECT pap.accrual_plan_id
1765: FROM pay_accrual_plans pap,
1766: pay_element_entries_f pee,
1767: pay_element_links_f pel,
1768: pay_element_types_f pet
1769: WHERE pel.element_link_id = pee.element_link_id
1770: AND pel.element_type_id = pet.element_type_id

Line 1825: FROM pay_element_entries_f pee,

1821: ,c_accrual_plan_id NUMBER
1822: ,c_calculation_date DATE
1823: ,c_assignment_id NUMBER) IS
1824: SELECT NVL(TO_DATE(pev.screen_entry_value,'YYYY/MM/DD HH24:MI:SS'),pps.date_start)
1825: FROM pay_element_entries_f pee,
1826: pay_element_entry_values_f pev,
1827: pay_input_values_f piv,
1828: pay_accrual_plans pap,
1829: hr_lookups hrl,

Line 2468: ,pay_element_entries_f pee

2464: ,pay_element_types_f pet
2465: ,pay_element_links_f pel
2466: ,pay_input_values_f piv1
2467: ,pay_input_values_f piv2
2468: ,pay_element_entries_f pee
2469: ,pay_element_entry_values_f pev1
2470: ,pay_element_entry_values_f pev2
2471: where
2472: pee.assignment_id = v_assignment_id

Line 2674: /*Bug# 8604518 --In the cursor,the date joins on the table 'pay_element_entries_f' are modified

2670: end validate_accrual_plan_name;
2671:
2672: /*Bug# 7607177 --This function is called from AU_ANNUAL_LEAVE_ACCRUAL_DAILY fast formula
2673: to get the correct enrollment start date for calculating the PTO Accruals*/
2674: /*Bug# 8604518 --In the cursor,the date joins on the table 'pay_element_entries_f' are modified
2675: to return rows when Annual Leave and LSL are paid to terminated employees */
2676: function au_get_enrollment_startdate
2677: ( p_accrual_plan_id in number
2678: ,p_assignment_id in number

Line 2693: pay_element_entries_f pee,

2689: select min(PEE.EFFECTIVE_START_DATE)
2690: from pay_accrual_plans pap,
2691: pay_element_types_f pet,
2692: pay_element_links_f pel,
2693: pay_element_entries_f pee,
2694: per_assignments_f paf,
2695: per_periods_of_service pps
2696: where pee.element_link_id = pel.element_link_id
2697: and pel.element_type_id = pet.element_type_id