APPS.PER_ABSENCE_ATTENDANCES_PKG dependencies on PAY_ELEMENT_TYPES_F

Line 448: from pay_element_types_f ele1

444: end if;
445:
446: select decode(l_maternity.partner_death_date,null,to_number (ele1.element_information12),to_number (ele1.element_information13))
447: into l_apl_max_weeks
448: from pay_element_types_f ele1
449: where ele1.element_name = ssp_apab_pkg.c_APAB_element_name
450: and l_maternity.due_date between ele1.effective_start_date
451: and ele1.effective_end_date;
452:

Line 471: from pay_element_types_f ele1

467: end if;
468:
469: select decode(l_maternity.partner_death_date,null,to_number (ele1.element_information11),to_number (ele1.element_information12))
470: into l_apl_max_weeks
471: from pay_element_types_f ele1
472: where ele1.element_name = ssp_apad_pkg.c_APAD_element_name
473: and l_maternity.due_date between ele1.effective_start_date
474: and ele1.effective_end_date;
475:

Line 2404: pay_element_types_f t,

2400: l.element_link_id,
2401: asg.payroll_id,
2402: 'X'
2403: from per_assignments_f asg,
2404: pay_element_types_f t,
2405: pay_element_links_f l
2406: where l.business_group_id + 0 = p_bgroup_id
2407: and t.element_type_id = p_eltype
2408: and asg.person_id = p_per_id

Line 2464: pay_element_types_f pet,

2460:
2461: cursor c16 is
2462: select pettl.element_name
2463: from per_absence_attendance_types paa,
2464: pay_element_types_f pet,
2465: pay_element_types_f_tl pettl
2466: where pet.element_type_id = p_eletype
2467: and paa.absence_attendance_type_id = p_abat_type
2468: and pet.element_type_id = pettl.element_type_id

Line 2465: pay_element_types_f_tl pettl

2461: cursor c16 is
2462: select pettl.element_name
2463: from per_absence_attendance_types paa,
2464: pay_element_types_f pet,
2465: pay_element_types_f_tl pettl
2466: where pet.element_type_id = p_eletype
2467: and paa.absence_attendance_type_id = p_abat_type
2468: and pet.element_type_id = pettl.element_type_id
2469: and nvl(p_dstart,paa.date_effective)