APPS.PAY_FR_SICKNESS_CALC dependencies on PER_WORK_INCIDENTS

Line 1660: , per_work_incidents inc

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'
1664: and decode(paa.abs_information_category,'FR_S',to_number(paa.abs_information6),null) = inc.incident_id(+);

Line 1686: , per_work_incidents inc

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: --
1690: cursor c_get_child_absence(p_parent_absence_id number

Line 4079: per_work_incidents pwi

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
4081: and pabs.abs_information_category ='FR_S'
4082: and pabs.date_start <= p_payment_start_date
4083: and pabs.date_end >= p_payment_end_date

Line 4105: , per_work_incidents inc

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: --
4109: cursor c_get_child_absence(p_parent_absence_id number