DBA Data[Home] [Help]

APPS.PAY_NO_EMP_CONT dependencies on PER_ALL_ASSIGNMENTS_F

Line 1617: ,per_all_assignments_f asg

1613: -- get the dob from asg_act_id and date_earned
1614: select date_of_birth
1615: into l_dob
1616: from per_all_people_f pap
1617: ,per_all_assignments_f asg
1618: ,pay_assignment_actions assact
1619: where assact.ASSIGNMENT_ACTION_ID = p_assignment_action_id
1620: and assact.assignment_id = asg.assignment_id
1621: and p_date_earned between asg.effective_start_date and asg.effective_end_date