APPS.PAY_US_PAYSLIP_SIMULATION_MAIN dependencies on PER_ALL_PEOPLE_F

Line 1283: per_all_people_f ppf,

1279: paf.business_group_id,
1280: paf.soft_coding_keyflex_id,
1281: paf.hourly_salaried_code
1282: FROM per_assignments_f paf,
1283: per_all_people_f ppf,
1284: per_all_people_f ppf1,
1285: per_periods_of_service pps
1286: WHERE paf.person_id = ppf.person_id
1287: AND paf.assignment_id = cp_assignment_id

Line 1284: per_all_people_f ppf1,

1280: paf.soft_coding_keyflex_id,
1281: paf.hourly_salaried_code
1282: FROM per_assignments_f paf,
1283: per_all_people_f ppf,
1284: per_all_people_f ppf1,
1285: per_periods_of_service pps
1286: WHERE paf.person_id = ppf.person_id
1287: AND paf.assignment_id = cp_assignment_id
1288: AND ppf1.person_id = ppf.person_id

Line 1357: FROM per_all_people_f ppf

1353: first_name || ' ' ||
1354: DECODE(NVL(LENGTH(LTRIM(RTRIM(middle_names))),0), 0, NULL,
1355: UPPER(SUBSTR(middle_names,1,1)) || '. ' ) ||
1356: pre_name_adjunct || last_name || ' '|| suffix))
1357: FROM per_all_people_f ppf
1358: WHERE ppf.person_id = cp_person_id
1359: AND cp_effective_date between ppf.effective_start_date
1360: and ppf.effective_end_date;
1361:

Line 2224: ,per_all_people_f ppf

2220: SELECT NVL(paf.work_at_home, 'N')
2221: ,ppf.person_id
2222: ,ppf.business_group_id
2223: FROM per_assignments_f paf
2224: ,per_all_people_f ppf
2225: WHERE paf.assignment_id = cp_assignment_id
2226: AND paf.person_id = ppf.person_id;
2227:
2228: CURSOR c_cur_home_state_jd(cp_person_id NUMBER