APPS.PQP_US_SRS_EXTRACTS dependencies on PER_ALL_PEOPLE_F

Line 876: Cursor csr_chk_person ( c_person_id In per_all_people_f.person_id%TYPE

872: ,eat.ext_dfn_id
873: From pqp_extract_attributes eat
874: Where eat.ext_dfn_id = ben_ext_thread.g_ext_dfn_id;
875:
876: Cursor csr_chk_person ( c_person_id In per_all_people_f.person_id%TYPE
877: ,c_effective_date In Date ) Is
878: select *
879: from per_all_people_f
880: where person_id = c_person_id

Line 879: from per_all_people_f

875:
876: Cursor csr_chk_person ( c_person_id In per_all_people_f.person_id%TYPE
877: ,c_effective_date In Date ) Is
878: select *
879: from per_all_people_f
880: where person_id = c_person_id
881: and c_effective_date between effective_start_date
882: and effective_end_date;
883:

Line 1066: ,p_person_id in per_all_people_f.person_id%TYPE

1062: -- ~ Get_Secondary_Assignments : Fetchs all the Secondary Assignments ~
1063: -- ===============================================================================
1064: Function Get_Secondary_Assignments
1065: ( p_primary_assignment_id in per_all_assignments_f.assignment_id%TYPE
1066: ,p_person_id in per_all_people_f.person_id%TYPE
1067: ,p_effective_date in date
1068: ,p_extract_start_date in date
1069: ,p_extract_end_date in date ) Return Varchar2 Is
1070:

Line 1359: ,p_person_id In per_all_people_f.person_id%TYPE

1355: -- ================================================================================
1356: Procedure Create_New_Lines
1357: (p_pri_assignment_id In per_all_assignments_f.assignment_id%TYPE
1358: ,p_sec_assignment_id In per_all_assignments_f.assignment_id%TYPE
1359: ,p_person_id In per_all_people_f.person_id%TYPE
1360: ,p_record_name In Varchar2
1361: ) Is
1362:
1363: --