DBA Data[Home] [Help]

APPS.GHR_PA_REQUESTS_PKG dependencies on PER_ASSIGNMENTS_F

Line 104: p_business_group_id in per_assignments_f.business_group_id%type)

100:
101: FUNCTION get_occ_series(
102: p_position_id hr_all_positions_f.position_id%TYPE
103: ,p_effective_date date default sysdate,
104: p_business_group_id in per_assignments_f.business_group_id%type)
105: RETURN VARCHAR2;
106:
107: FUNCTION get_appropriation_code(
108: p_position_id hr_all_positions_f.position_id%TYPE

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

111:
112: --Bug# 9647383
113: FUNCTION get_pos_organization( p_position_id hr_all_positions_f.position_id%TYPE
114: ,p_effective_date date default sysdate
115: ,p_business_group_id in per_assignments_f.business_group_id%type)
116: RETURN VARCHAR2;
117: --End bug# 8653508
118:
119: --Begin Bug# 13684234

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

168: ,p_veterans_pref_for_rif OUT NOCOPY varchar2
169: ,p_veterans_status OUT NOCOPY varchar2
170: ,p_scd_leave OUT NOCOPY varchar2);
171: --
172: PROCEDURE get_SF52_asg_ddf_details (p_assignment_id IN per_assignments_f.assignment_id%TYPE
173: ,p_date_effective IN date default sysdate
174: ,p_tenure OUT NOCOPY varchar2
175: ,p_annuitant_indicator OUT NOCOPY varchar2
176: ,p_pay_rate_determinant OUT NOCOPY varchar2