APPS.PAY_FR_PTO_PKG dependencies on PAY_ELEMENT_LINKS_F

Line 88: from pay_element_links_f

84: where pap.business_group_id + 0 = p_business_group_id
85: and asg.assignment_id = p_assignment_id
86: and p_date_earned between asg.effective_start_date and asg.effective_end_date
87: and pee.element_link_id in (select element_link_id
88: from pay_element_links_f
89: where element_type_id = pap.accrual_plan_element_type_id
90: )
91: and pee.assignment_id = p_assignment_id
92: and p_date_earned between pee.effective_start_date and pee.effective_end_date;

Line 3775: from pay_element_links_f

3771: ,sum(to_number(nvl(paa.abs_information6,'0'))) /* Young mothers days booked */
3772: from per_absence_attendances paa
3773: ,pay_element_entries_f pee
3774: where pee.element_link_id in (select element_link_id
3775: from pay_element_links_f
3776: where element_type_id = p_holiday_element_id
3777: )
3778: and pee.creator_type = 'A'
3779: and paa.absence_Attendance_id = pee.creator_id

Line 3967: from pay_element_links_f

3963: where
3964: pee.element_entry_id = peevM.element_entry_id
3965: and pee.element_entry_id = peevP.element_entry_id(+)
3966: and pee.element_link_id in (select element_link_id
3967: from pay_element_links_f
3968: where element_type_id = l_accrual_plan_element_id
3969: )
3970: and peevM.input_value_id = l_working_days_iv_id
3971: and peevP.input_value_id(+) = l_protected_days_iv_id

Line 5192: ,pay_element_links_f pel

5188: CURSOR csr_get_plan is
5189: select pap.accrual_plan_id
5190: from pay_accrual_plans pap
5191: ,pay_element_entries_f pee
5192: ,pay_element_links_f pel
5193: where pee.element_entry_id = P_ELEMENT_ENTRY_ID
5194: and pee.element_link_id = pel.element_link_id
5195: and pel.element_type_id = pap.accrual_plan_element_type_id;
5196:

Line 5833: from pay_element_links_f

5829: select NVL(sum(paa.abs_information2), -1)
5830: from per_absence_attendances paa
5831: ,pay_element_entries_f pee
5832: where pee.element_link_id in (select element_link_id
5833: from pay_element_links_f
5834: where element_type_id = p_holiday_Element_id
5835: )
5836: and pee.creator_type = 'A'
5837: and paa.absence_Attendance_id = pee.creator_id

Line 5916: from pay_element_links_f

5912: select 1
5913: from per_absence_attendances paa
5914: ,pay_element_entries_f pee
5915: where pee.element_link_id in (select element_link_id
5916: from pay_element_links_f
5917: where element_type_id = p_holiday_element_id
5918: )
5919: and pee.creator_type = 'A'
5920: and paa.absence_Attendance_id = pee.creator_id