DBA Data[Home] [Help]

APPS.PQP_US_SRS_EXTRACTS dependencies on PER_ALL_PEOPLE_F

Line 200: ,c_person_id In per_all_people_f.person_id%TYPE

196: -- Cursor to get the secondary assig. records active as of the given period.
197: --
198: Cursor csr_sec_assignments
199: (c_primary_assignment_id In per_all_assignments_f.assignment_id%TYPE
200: ,c_person_id In per_all_people_f.person_id%TYPE
201: ,c_effective_date In date
202: ,c_extract_start_date In date
203: ,c_extract_end_date In Date ) Is
204: Select *

Line 307: ,p_person_id In per_all_people_f.person_id%TYPE

303: ) Return Varchar2;
304: Procedure Create_New_Lines
305: (p_pri_assignment_id In per_all_assignments_f.assignment_id%TYPE
306: ,p_sec_assignment_id In per_all_assignments_f.assignment_id%TYPE
307: ,p_person_id In per_all_people_f.person_id%TYPE
308: ,p_record_name In Varchar2
309: );
310:
311: Function Get_Secondary_Assignments

Line 313: ,p_person_id In per_all_people_f.person_id%TYPE

309: );
310:
311: Function Get_Secondary_Assignments
312: (p_primary_assignment_id In per_all_assignments_f.assignment_id%TYPE
313: ,p_person_id In per_all_people_f.person_id%TYPE
314: ,p_effective_date In date
315: ,p_extract_start_date In date
316: ,p_extract_end_date In date ) Return Varchar2;
317: