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'

Line 2422: p_business_group_id in per_assignments_f.business_group_id%type

2418: End get_duty_station;
2419:
2420: FUNCTION get_occ_series(p_position_id in hr_all_positions_f.position_id%TYPE,
2421: p_effective_date in date default sysdate,
2422: p_business_group_id in per_assignments_f.business_group_id%type
2423: ) RETURN varchar2 IS
2424:
2425:
2426: l_proc varchar2(72) := 'get_occ_series';

Line 2476: ,p_business_group_id in per_assignments_f.business_group_id%type)

2472: END get_appropriation_code;
2473: --Begin 9647383
2474: FUNCTION get_pos_organization( p_position_id hr_all_positions_f.position_id%TYPE
2475: ,p_effective_date date default sysdate
2476: ,p_business_group_id in per_assignments_f.business_group_id%type)
2477: RETURN VARCHAR2 IS
2478:
2479: l_proc varchar2(72) := 'get_pos_organization';
2480: