eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_FR_SICKNESS_CALC dependencies on PER_ABSENCE_ATTENDANCES

Line 834: FROM per_absence_attendances pabs,

830: SELECT pabs.person_id person,
831: pabs.abs_information1 parent_abs,
832: papf.original_date_of_hire hiredate,
833: pabs.date_start abs_start
834: FROM per_absence_attendances pabs,
835: per_all_people_f papf
836: WHERE pabs.absence_attendance_id = p_absence_id
837: AND pabs.business_group_id = p_business_group_id
838: AND pabs.abs_information_category ='FR_S'

Line 848: FROM per_absence_attendances pabs

844: Cursor csr_abs_detail(c_absence_id NUMBER) IS
845: SELECT pabs.date_start abs_start_date,
846: pabs.abs_information8 ijss_cal,
847: nvl(fnd_date.canonical_to_date(pabs.abs_information7),hr_general.end_of_time) elig_dt
848: FROM per_absence_attendances pabs
849: WHERE pabs.absence_attendance_id = c_absence_id
850: AND pabs.business_group_id = p_business_group_id
851: AND pabs.abs_information_category ='FR_S';
852:

Line 856: FROM per_absence_attendances pabs_hol,

852:
853: -- Cursor for finding holidays within the date range
854: Cursor csr_holidays(c_hol_date varchar2, c_person_id Number) IS
855: SELECT count(*)
856: FROM per_absence_attendances pabs_hol,
857: per_absence_attendance_types pabt
858: WHERE pabs_hol.person_id = c_person_id
859: AND pabs_hol.business_group_id = p_business_group_id
860: AND c_hol_date BETWEEN pabs_hol.date_start AND pabs_hol.date_end

Line 867: FROM per_absence_attendances pabs,

863:
864: -- check if a maternity absence exists within 48 hours of this sickness
865: Cursor csr_maternity(c_sick_start_date date, c_person_id Number) IS
866: SELECT nvl(min('Y'),'N') maternity_related
867: FROM per_absence_attendances pabs,
868: per_absence_attendance_types pabt
869: WHERE pabs.person_id = c_person_id
870: AND (c_sick_start_date - 3 ) BETWEEN pabs.date_start AND pabs.date_end
871: AND pabt.absence_attendance_type_id = pabs.absence_attendance_type_id

Line 1390: FROM per_absence_Attendances

1386: SELECT abs_information9 SMID_6,
1387: abs_information10 SMID_12,
1388: abs_information11 hrs_200,
1389: abs_information12 hrs_800
1390: FROM per_absence_Attendances
1391: WHERE absence_Attendance_id = p_absence_id
1392: AND business_group_id = p_business_group_id
1393: AND abs_information_category ='FR_S';
1394:

Line 1542: FROM per_absence_attendances

1538:
1539: -- Cursor fetching absence details
1540: Cursor csr_abs_details IS
1541: SELECT date_start, date_end,absence_attendance_id,abs_information2
1542: FROM per_absence_attendances
1543: WHERE person_id = p_person_id
1544: AND ( absence_attendance_id = p_parent_abs_id
1545: OR abs_information1 = to_char(p_parent_abs_id))
1546: AND business_group_id = p_business_group_id

Line 1553: FROM per_absence_attendances

1549: --
1550: -- Cursor for subrogation details
1551: Cursor csr_subr_details IS
1552: SELECT date_start, date_end,abs_information2
1553: FROM per_absence_attendances
1554: WHERE person_id = p_person_id
1555: AND (absence_attendance_id = p_parent_abs_id
1556: OR abs_information1 = to_char(p_parent_abs_id))
1557: AND business_group_id = p_business_group_id

Line 1565: FROM per_absence_attendances pabs,

1561:
1562: -- check if a maternity absence exists within 48 hours of this sickness
1563: Cursor csr_maternity(c_sick_start_date date, c_person_id Number) IS
1564: SELECT nvl(min('Y'),'N') maternity_related
1565: FROM per_absence_attendances pabs,
1566: per_absence_attendance_types pabt
1567: WHERE pabs.person_id = c_person_id
1568: AND (c_sick_start_date - 3 ) BETWEEN pabs.date_start AND pabs.date_end
1569: AND pabt.absence_attendance_type_id = pabs.absence_attendance_type_id

Line 1658: from per_absence_attendances paa

1654: , paa.abs_information8 estimated
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

Line 1685: from per_absence_attendances paa

1681: , paa.abs_information8 estimated
1682: , nvl(inc.inc_information1,'N') work_incident
1683: , paa.person_id
1684: , paa.business_group_id
1685: from per_absence_attendances paa
1686: , per_work_incidents inc
1687: where paa.absence_attendance_id = p_absence_attendance_id
1688: and paa.abs_information6 = to_char(inc.incident_id(+));
1689: --

Line 1706: from per_absence_attendances

1702: , null estimated
1703: , null work_incident
1704: , person_id
1705: , business_group_id
1706: from per_absence_attendances
1707: where abs_information1 = to_char(p_parent_absence_id)
1708: and date_end <= p_max_end_date
1709: and person_id = p_person_id
1710: and business_group_id = p_business_group_id

Line 2081: ,per_absence_attendances paa

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
2083: and peef.element_link_id = pelf.element_link_id
2084: and pelf.element_type_id = petf.element_type_id
2085: and p_asg.action_start_date between pelf.effective_start_date and pelf.effective_end_date

Line 3272: FROM per_absence_attendances paa,

3268: )/12), 4)
3269: --paa.date_start
3270: INTO l_svc_in_years
3271: --l_parent_absence_start_date
3272: FROM per_absence_attendances paa,
3273: per_periods_of_service ps,
3274: per_all_assignments_f pas
3275: WHERE ps.person_id = pas.person_id
3276: AND pas.assignment_id = l_assgt_id

Line 4076: from per_absence_attendances pabs,

4072: , null effective_end_date
4073: , nvl(abs_information2, 'Y') subrogated
4074: , nvl(pabs.abs_information8, 'N') estimated
4075: , nvl(pwi.inc_information1,'N') work_incident
4076: from per_absence_attendances pabs,
4077: per_all_assignments_f pasg,
4078: per_absence_attendance_types pabt,
4079: per_work_incidents pwi
4080: where pabs.business_group_id = p_business_group_id

Line 4104: from per_absence_attendances paa

4100: , null effective_end_date
4101: , nvl(abs_information2, 'Y') subrogated
4102: , nvl(paa.abs_information8,'N') estimated
4103: , nvl(inc.inc_information1,'N') work_incident
4104: from per_absence_attendances paa
4105: , per_work_incidents inc
4106: where paa.absence_attendance_id = p_absence_attendance_id
4107: and paa.abs_information6 = to_char(inc.incident_id(+));
4108: --

Line 4120: from per_absence_attendances a,

4116: , null effective_start_date
4117: , null effective_end_date
4118: , null estimated
4119: , null work_incident
4120: from per_absence_attendances a,
4121: per_absence_attendances p
4122: where a.abs_information1 = to_char(p_parent_absence_id)
4123: and p.absence_attendance_id = p_parent_absence_id
4124: and a.person_id = p.person_id

Line 4121: per_absence_attendances p

4117: , null effective_end_date
4118: , null estimated
4119: , null work_incident
4120: from per_absence_attendances a,
4121: per_absence_attendances p
4122: where a.abs_information1 = to_char(p_parent_absence_id)
4123: and p.absence_attendance_id = p_parent_absence_id
4124: and a.person_id = p.person_id
4125: and a.date_end <= p_max_end_date

Line 4303: FROM per_absence_attendances pabs_hol,

4299: --
4300: -- Cursor for finding holidays within the date range
4301: Cursor csr_holidays(c_hol_date varchar2) IS
4302: SELECT 'H'
4303: FROM per_absence_attendances pabs_hol,
4304: per_absence_attendance_types pabt,
4305: per_absence_attendances pabs_sick
4306: WHERE pabs_sick.absence_attendance_id = p_absence_id
4307: AND pabs_sick.business_group_id = p_business_group_id

Line 4305: per_absence_attendances pabs_sick

4301: Cursor csr_holidays(c_hol_date varchar2) IS
4302: SELECT 'H'
4303: FROM per_absence_attendances pabs_hol,
4304: per_absence_attendance_types pabt,
4305: per_absence_attendances pabs_sick
4306: WHERE pabs_sick.absence_attendance_id = p_absence_id
4307: AND pabs_sick.business_group_id = p_business_group_id
4308: AND pabs_hol.person_id = pabs_sick.person_id
4309: AND pabs_hol.business_group_id = p_business_group_id