APPS.PO_DOCUMENT_ACTION_PVT dependencies on PER_ALL_ASSIGNMENTS_F

Line 1357: per_all_assignments_f a,

1353: CURSOR direct_pos(p_emp_id NUMBER, p_path_id NUMBER) IS
1354: SELECT /*+ ordered use_nl (poeh a p past b) */ poeh.superior_id
1355: FROM po_employee_hierarchies_all poeh,
1356: per_all_people_f p,
1357: per_all_assignments_f a,
1358: per_assignment_status_types past
1359: WHERE a.person_id = p.person_id
1360: AND poeh.business_group_id in (select fsp.business_group_id
1361: from financials_system_parameters fsp)

Line 1384: hr_security.Show_record('PER_ALL_ASSIGNMENTS_F',

1380: p.employee_number,
1381: p.applicant_number,
1382: p.npw_number))
1383: AND 'TRUE' = Decode(hr_security.view_all, 'Y', 'TRUE',
1384: hr_security.Show_record('PER_ALL_ASSIGNMENTS_F',
1385: a.assignment_id,
1386: a.person_id,
1387: a.assignment_type))
1388: ORDER BY poeh.superior_level, p.full_name;

Line 1423: per_all_assignments_f a,

1419: CURSOR hier_pos(p_emp_id NUMBER, p_path_id NUMBER) IS
1420: SELECT /*+ ordered use_nl (poeh a p past b) */ poeh.superior_id
1421: FROM po_employee_hierarchies_all poeh,
1422: per_all_people_f p,
1423: per_all_assignments_f a,
1424: per_assignment_status_types past
1425: WHERE a.person_id = p.person_id
1426: AND poeh.business_group_id in (select fsp.business_group_id
1427: from financials_system_parameters fsp)

Line 1450: hr_security.Show_record('PER_ALL_ASSIGNMENTS_F',

1446: p.employee_number,
1447: p.applicant_number,
1448: p.npw_number))
1449: AND 'TRUE' = Decode(hr_security.view_all, 'Y', 'TRUE',
1450: hr_security.Show_record('PER_ALL_ASSIGNMENTS_F',
1451: a.assignment_id,
1452: a.person_id,
1453: a.assignment_type))
1454: ORDER BY p.full_name;