APPS.PQP_US_PENSION_EXTRACTS dependencies on PER_ALL_PEOPLE_F

Line 292: ,c_person_id IN per_all_people_f.person_id%TYPE

288: -- Cursor to chk for other primary assig. within the extract date range.
289: -- =============================================================================
290: CURSOR csr_sec_assg
291: (c_primary_assignment_id IN per_all_assignments_f.assignment_id%TYPE
292: ,c_person_id IN per_all_people_f.person_id%TYPE
293: ,c_effective_date IN DATE
294: ,c_extract_start_date IN DATE
295: ,c_extract_end_date IN DATE ) IS
296: SELECT asg.person_id

Line 395: FROM per_all_people_f paf

391: ,ppt.system_person_type
392: ,pps.actual_termination_date
393: ,pps.date_start
394: ,paf.original_date_of_hire
395: FROM per_all_people_f paf
396: ,per_person_types ppt
397: ,per_periods_of_service pps
398: WHERE paf.person_id = c_person_id
399: AND ppt.person_type_id = paf.person_type_id

Line 2857: l_person_id per_all_people_f.person_id%TYPE;

2853: l_ff_value ben_ext_rslt_dtl.val_01%TYPE;
2854: l_ff_value_fmt ben_ext_rslt_dtl.val_01%TYPE;
2855: l_max_len NUMBER;
2856: l_rqd_elmt_is_present VARCHAR2(2) := 'Y';
2857: l_person_id per_all_people_f.person_id%TYPE;
2858: --
2859: l_val_tab ValTabTyp;
2860: l_exclude_this_rcd_flag BOOLEAN;
2861: l_raise_warning BOOLEAN;

Line 3656: l_person_id per_all_people_f.person_id%TYPE;

3652: l_warning_message VARCHAR2(2000);
3653: l_error_message VARCHAR2(2000);
3654: l_asg_type per_all_assignments_f.assignment_type%TYPE;
3655: l_main_rec csr_rslt_dtl%ROWTYPE;
3656: l_person_id per_all_people_f.person_id%TYPE;
3657: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
3658: BEGIN
3659: Hr_Utility.set_location('Entering: '||l_proc_name, 5);
3660: i := p_business_group_id;