APPS.PQP_PENSION_EXTRACTS dependencies on PER_ALL_PEOPLE_F

Line 320: FROM per_all_people_f paf

316: ,ppt.system_person_type
317: ,pps.actual_termination_date
318: ,pps.date_start
319: ,paf.original_date_of_hire
320: FROM per_all_people_f paf
321: ,per_person_types ppt
322: ,per_periods_of_service pps
323: WHERE paf.person_id = c_person_id
324: AND ppt.person_type_id = paf.person_type_id

Line 364: ,c_person_id IN per_all_people_f.person_id%TYPE

360: -- date range.
361: -- =============================================================================
362: CURSOR csr_sec_assg
363: (c_primary_assignment_id IN per_all_assignments_f.assignment_id%TYPE
364: ,c_person_id IN per_all_people_f.person_id%TYPE
365: ,c_effective_date IN DATE
366: ,c_extract_start_date IN DATE
367: ,c_extract_end_date IN DATE ) IS
368: SELECT asg.person_id

Line 2041: l_person_id per_all_people_f.person_id%TYPE;

2037: l_ff_value ben_ext_rslt_dtl.val_01%TYPE;
2038: l_ff_value_fmt ben_ext_rslt_dtl.val_01%TYPE;
2039: l_max_len NUMBER;
2040: l_rqd_elmt_is_present VARCHAR2(2) := 'Y';
2041: l_person_id per_all_people_f.person_id%TYPE;
2042: --
2043: l_val_tab ValTabTyp;
2044: l_exclude_this_rcd_flag BOOLEAN;
2045: l_raise_warning BOOLEAN;

Line 2459: l_person_id per_all_people_f.person_id%TYPE;

2455: l_warning_message VARCHAR2(2000);
2456: l_error_message VARCHAR2(2000);
2457: l_asg_type per_all_assignments_f.assignment_type%TYPE;
2458: l_main_rec csr_rslt_dtl%ROWTYPE;
2459: l_person_id per_all_people_f.person_id%TYPE;
2460: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
2461: BEGIN
2462:
2463: hr_utility.set_location('Entering: '||l_proc_name, 5);

Line 2871: |Further Person Information |Person Developer DF |PER_ALL_PEOPLE_F |

2867: |Assignment Extra Information |PER_ASSIGNMENT_EXTRA_INFO| -DO- |
2868: |Extra Person Information |Extra Person Info DDF |PER_PEOPLE_EXTRA_INFO |
2869: |Extra Person Info. Details |PER_PEOPLE_EXTRA_INFO | -DO- |
2870: |Org Developer DF |Org Developer DF |HR_ORGANIZATION_INFORMATION |
2871: |Further Person Information |Person Developer DF |PER_ALL_PEOPLE_F |
2872: | | | |
2873: +=============================+=========================+============================+
2874: */
2875:

Line 2992: l_tab_name := 'PER_ALL_PEOPLE_F';

2988: RAISE Invaild_DDF_or_DF;
2989: END IF;
2990: l_key_val := g_person_id;
2991: l_key_col := 'PERSON_ID';
2992: l_tab_name := 'PER_ALL_PEOPLE_F';
2993: ELSE
2994: Hr_Utility.set_location('..Invalid p_flex_name = '||p_flex_name, 8);
2995: RAISE Invaild_DDF_or_DF;
2996: END IF;

Line 3811: FROM per_all_people_f paf

3807: SELECT paf.person_type_id
3808: ,paa.location_id
3809: ,paa.organization_id
3810:
3811: FROM per_all_people_f paf
3812: ,per_all_assignments_f paa
3813: WHERE paf.person_id = c_person_id
3814: AND paa.person_id = paf.person_id
3815: AND paa.assignment_type = 'E'