APPS.GHR_NFC_POSITION_EXTRACTS dependencies on PER_ALL_ASSIGNMENTS_F

Line 63: g_business_group_id per_all_assignments_f.business_group_id%TYPE;

59: g_job_kff t_pqp_metadata_master;
60: g_master_data t_pqp_record_values;
61: g_individual_data t_pqp_record_values;
62: g_position_id NUMBER;
63: g_business_group_id per_all_assignments_f.business_group_id%TYPE;
64: g_user_id VARCHAR2(20);
65: g_dept_code VARCHAR2(20);
66: g_agency_code VARCHAR2(20);
67: g_poi VARCHAR2(20);

Line 176: (p_business_group_id IN per_all_assignments_f.business_group_id%TYPE

172: -- for the position extract.
173: -- =============================================================================
174:
175: FUNCTION Position_Sub_Header_Criteria
176: (p_business_group_id IN per_all_assignments_f.business_group_id%TYPE
177: ,p_position_id IN hr_all_positions_f.position_id%TYPE
178: ,p_warning_message OUT NOCOPY Varchar2
179: ,p_error_message OUT NOCOPY Varchar2
180: ) RETURN Varchar2 ;

Line 225: (p_business_group_id IN per_all_assignments_f.business_group_id%TYPE

221: -- =============================================================================
222: -- ~ Position_Person_Main_Criteria:
223: -- =============================================================================
224: FUNCTION Position_Person_Main_Criteria
225: (p_business_group_id IN per_all_assignments_f.business_group_id%TYPE
226: ,p_effective_date IN Date
227: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
228: ,p_warning_message OUT NOCOPY Varchar2
229: ,p_error_message OUT NOCOPY Varchar2

Line 227: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE

223: -- =============================================================================
224: FUNCTION Position_Person_Main_Criteria
225: (p_business_group_id IN per_all_assignments_f.business_group_id%TYPE
226: ,p_effective_date IN Date
227: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
228: ,p_warning_message OUT NOCOPY Varchar2
229: ,p_error_message OUT NOCOPY Varchar2
230: ) RETURN Varchar2 ;
231: -- =============================================================================