DBA Data[Home] [Help]

APPS.PAY_GB_RTI_FPS_VALIDATE_13 dependencies on PER_ALL_PEOPLE_F

Line 1895: per_all_people_f papf where

1891: -- fetch the details using asg action id
1892: hr_utility.set_location('Getting from asg_act_id' ,2);
1893: select paaf.assignment_number,papf.sex into l_assignment_number,l_gender from per_all_assignments_f paaf,
1894: pay_assignment_Actions paa ,
1895: per_all_people_f papf where
1896: paa.assignment_action_id = p_assactid
1897: and paa.assignment_id = paaf.assignment_id
1898: and paaf.person_id = papf.person_id
1899: and p_effective_date between paaf.effective_start_date and paaf.effective_end_date