DBA Data[Home] [Help]

APPS.PER_PAY_PROPOSALS_POPULATE dependencies on HR_ALL_POSITIONS_F

Line 581: from hr_all_positions_f pos

577: ,'M',12
578: ,'W',52
579: ,'D',365
580: ,1)
581: from hr_all_positions_f pos
582: , per_all_assignments_f asg
583: where p_date BETWEEN pos.effective_start_date AND pos.effective_end_date
584: and asg.assignment_id =p_assignment_id
585: and p_date between asg.effective_start_date