APPS.PAY_FR_SICKNESS_CALC dependencies on PAY_ELEMENT_ENTRIES_F

Line 1659: , pay_element_entries_f pee

1655: , nvl(inc.inc_information1,'N') work_incident
1656: , paa.person_id
1657: , paa.business_group_id
1658: from per_absence_attendances paa
1659: , pay_element_entries_f pee
1660: , per_work_incidents inc
1661: where pee.element_entry_id = p_element_entry_id
1662: and paa.absence_attendance_id = pee.creator_id
1663: and pee.creator_type = 'A'

Line 1669: from pay_element_entries_f

1665: --
1666: cursor c_get_entry_dates is
1667: select min(effective_start_date)
1668: , max(effective_end_date)
1669: from pay_element_entries_f
1670: where element_entry_id = p_element_entry_id;
1671: --
1672: cursor c_get_parent_absence(p_absence_attendance_id number) is
1673: select paa.absence_attendance_id

Line 2078: pay_element_entries_f peef

2074: paa.date_start Abs_start_date,
2075: paa.date_end Abs_end_date,
2076: nvl(paa.abs_information8,'N') IJSS_estimate
2077: from
2078: pay_element_entries_f peef
2079: ,pay_element_links_f pelf
2080: ,pay_element_types_f petf
2081: ,per_absence_attendances paa
2082: where peef.assignment_id = p_asg.assignment_id

Line 2179: pay_element_entries_f pentf,

2175: peval_pet.screen_entry_value pmt_end_date
2176: --
2177: from pay_element_entry_values_f peval_pst,
2178: pay_element_entry_values_f peval_pet,
2179: pay_element_entries_f pentf,
2180: pay_element_links_f plink,
2181: pay_element_types_f peltf
2182: --
2183: where pentf.assignment_id = p_asg.assignment_id

Line 2691: ,pay_element_entries_f ee

2687: ,pay_run_result_values guarantee_id
2688: ,pay_run_result_values parent_absence_id
2689: ,pay_run_result_values target
2690: ,pay_entry_process_details epd
2691: ,pay_element_entries_f ee
2692: where assact.assignment_id = p_assignment_id
2693: and assact.payroll_action_id = pact.payroll_action_id
2694: and pact.action_type in ('R', 'Q', 'B')
2695: and pact.date_earned >= p_parent_absence_start_date

Line 3662: ,pay_element_entries_f ENT

3658: ,fnd_number.canonical_to_number(max(decode(ENT_PT.input_value_id,g_ben_band4_rate_iv_id,ENT_PT.screen_entry_value,null))) b4_rate
3659: ,max(decode(ENT_PT.input_value_id,g_ben_balance_iv_id,ENT_PT.screen_entry_value,null)) balance
3660: from pay_element_entry_values_f ENT_PT
3661: ,pay_element_entry_values_f G
3662: ,pay_element_entries_f ENT
3663: ,pay_element_links_f EL
3664: where ENT_PT.element_entry_id = ENT.element_entry_id
3665: and G.element_entry_id = ENT.element_entry_id
3666: and G.input_value_id = g_ben_guarantee_id_iv_id