DBA Data[Home] [Help]

APPS.PAY_FR_MAP_CALC dependencies on PER_ASSIGNMENTS_F

Line 806: ,per_assignments_f paf

802: , paa.date_end
803: , decode(paa.abs_information_category,'FR_M',to_number(paa.abs_information1)) parent_absence_id
804: , decode(paa.abs_information_category,'FR_M',NVL(paa.abs_information7,'N'),NVL(paa.abs_information4,'N')) estimated_ijss
805: from per_absence_attendances paa
806: ,per_assignments_f paf
807: where paf.assignment_id = p_assignment_id
808: and paf.person_id = paa.person_id
809: and p_date_earned between
810: paf.effective_start_date and paf.effective_end_date