APPS.GHR_CPDF_STATRPT dependencies on PER_PEOPLE_F

Line 124: PER_PEOPLE_F PER ,

120: CURSOR cur_per IS
121: SELECT
122: DECODE(PER.CURRENT_EMPLOYEE_FLAG, 'Y', PPS.DATE_START, DECODE(PER.CURRENT_NPW_FLAG, 'Y', PPP.DATE_START, NULL)) hire_date
123: FROM
124: PER_PEOPLE_F PER ,
125: PER_PERIODS_OF_SERVICE PPS ,
126: PER_PERIODS_OF_PLACEMENT PPP
127: WHERE
128: PPS.PERSON_ID (+) = PER.PERSON_ID AND

Line 209: FROM PER_PEOPLE_F

205: CURSOR PEOPLE_CUR IS
206: SELECT SEX,
207: DATE_OF_BIRTH,
208: NATIONAL_IDENTIFIER
209: FROM PER_PEOPLE_F
210: WHERE (TRUNC(p_sr_report_date) between effective_start_date and
211: effective_end_date) AND
212: PERSON_ID = g_person_id;
213:

Line 245: l_emp_number per_people_f.employee_number%TYPE;

241: )
242: IS
243: l_proc varchar2(30) := 'get_from_history_ancrit';
244: l_ANCRIT_REC ghr_api.special_information_type;
245: l_emp_number per_people_f.employee_number%TYPE;
246: CURSOR c_per IS
247: SELECT per.employee_number
248: FROM per_people_f per
249: WHERE per.person_id = p_sr_person_id

Line 248: FROM per_people_f per

244: l_ANCRIT_REC ghr_api.special_information_type;
245: l_emp_number per_people_f.employee_number%TYPE;
246: CURSOR c_per IS
247: SELECT per.employee_number
248: FROM per_people_f per
249: WHERE per.person_id = p_sr_person_id
250: AND NVL(p_sr_report_date, TRUNC(sysdate)) BETWEEN per.effective_start_date
251: AND per.effective_end_date;
252: BEGIN

Line 1287: CURSOR cur_per_details(p_person_id per_people_f.person_id%type)

1283: l_suffix per_all_people_f.title%type;
1284: l_last_name per_all_people_f.last_name%type;
1285:
1286:
1287: CURSOR cur_per_details(p_person_id per_people_f.person_id%type)
1288: IS
1289: --Bug # 9329643 added employee no
1290: SELECT full_name name ,national_identifier ssn,last_name,first_name,middle_names, title, employee_number
1291: FROM per_all_people_f

Line 1295: l_employee_number per_people_f.employee_number%TYPE;

1291: FROM per_all_people_f
1292: WHERE person_id=p_person_id;
1293:
1294: --Bug # 9329643
1295: l_employee_number per_people_f.employee_number%TYPE;
1296:
1297:
1298: l_business_group_id per_assignments_f.business_group_id%type;
1299: l_full_name per_people_f.full_name%type;

Line 1299: l_full_name per_people_f.full_name%type;

1295: l_employee_number per_people_f.employee_number%TYPE;
1296:
1297:
1298: l_business_group_id per_assignments_f.business_group_id%type;
1299: l_full_name per_people_f.full_name%type;
1300: l_ssn per_people_f.national_identifier%type;
1301: l_records_found BOOLEAN;
1302: l_mesgbuff1 VARCHAR2(4000);
1303: ll_per_ei_data per_people_extra_info%rowtype;

Line 1300: l_ssn per_people_f.national_identifier%type;

1296:
1297:
1298: l_business_group_id per_assignments_f.business_group_id%type;
1299: l_full_name per_people_f.full_name%type;
1300: l_ssn per_people_f.national_identifier%type;
1301: l_records_found BOOLEAN;
1302: l_mesgbuff1 VARCHAR2(4000);
1303: ll_per_ei_data per_people_extra_info%rowtype;
1304: -- FWFA Changes Declare variable l_calc_pay_table_id