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 205: FROM PER_PEOPLE_F

201: CURSOR PEOPLE_CUR IS
202: SELECT SEX,
203: DATE_OF_BIRTH,
204: NATIONAL_IDENTIFIER
205: FROM PER_PEOPLE_F
206: WHERE (TRUNC(p_sr_report_date) between effective_start_date and
207: effective_end_date) AND
208: PERSON_ID = g_person_id;
209:

Line 241: l_emp_number per_people_f.employee_number%TYPE;

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

Line 244: FROM per_people_f per

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

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

1252: l_suffix per_all_people_f.title%type;
1253: l_last_name per_all_people_f.last_name%type;
1254:
1255:
1256: CURSOR cur_per_details(p_person_id per_people_f.person_id%type)
1257: IS
1258: SELECT full_name name ,national_identifier ssn,last_name,first_name,middle_names, title
1259: FROM per_all_people_f
1260: WHERE person_id=p_person_id;

Line 1264: l_full_name per_people_f.full_name%type;

1260: WHERE person_id=p_person_id;
1261:
1262:
1263: l_business_group_id per_assignments_f.business_group_id%type;
1264: l_full_name per_people_f.full_name%type;
1265: l_ssn per_people_f.national_identifier%type;
1266: l_records_found BOOLEAN;
1267: l_mesgbuff1 VARCHAR2(4000);
1268: ll_per_ei_data per_people_extra_info%rowtype;

Line 1265: l_ssn per_people_f.national_identifier%type;

1261:
1262:
1263: l_business_group_id per_assignments_f.business_group_id%type;
1264: l_full_name per_people_f.full_name%type;
1265: l_ssn per_people_f.national_identifier%type;
1266: l_records_found BOOLEAN;
1267: l_mesgbuff1 VARCHAR2(4000);
1268: ll_per_ei_data per_people_extra_info%rowtype;
1269: -- FWFA Changes Declare variable l_calc_pay_table_id