DBA Data[Home] [Help]

APPS.GHR_PA_REQUESTS_PKG dependencies on PER_ASSIGNMENTS_F

Line 764: PROCEDURE get_SF52_asg_ddf_details (p_assignment_id IN per_assignments_f.assignment_id%TYPE

760:
761: END get_SF52_person_ddf_details;
762:
763: -- vsm
764: PROCEDURE get_SF52_asg_ddf_details (p_assignment_id IN per_assignments_f.assignment_id%TYPE
765: ,p_date_effective IN date default sysdate
766: ,p_tenure OUT NOCOPY varchar2
767: ,p_annuitant_indicator OUT NOCOPY varchar2
768: ,p_pay_rate_determinant OUT NOCOPY varchar2

Line 1962: FROM Per_assignments_f asg

1958: l_title varchar2(150);
1959:
1960: CURSOR c_per_pos is
1961: SELECT asg.position_id
1962: FROM Per_assignments_f asg
1963: WHERE asg.person_id = p_person_id
1964: AND trunc(nvl(p_effective_date,sysdate))
1965: between asg.effective_start_date and asg.effective_end_date
1966: AND asg.assignment_type <> 'B'