APPS.PO_DOCUMENT_ACTION_PVT dependencies on PER_ALL_ASSIGNMENTS_F

Line 1346: per_all_assignments_f a,

1342: CURSOR direct_pos(p_emp_id NUMBER, p_path_id NUMBER) IS
1343: SELECT /*+ ordered use_nl (poeh a p past b) */ poeh.superior_id
1344: FROM po_employee_hierarchies_all poeh,
1345: per_all_people_f p,
1346: per_all_assignments_f a,
1347: per_assignment_status_types past,
1348: per_periods_of_service b
1349: WHERE a.person_id = p.person_id
1350: AND poeh.business_group_id in (select fsp.business_group_id

Line 1375: hr_security.Show_record('PER_ALL_ASSIGNMENTS_F',

1371: p.employee_number,
1372: p.applicant_number,
1373: p.npw_number))
1374: AND 'TRUE' = Decode(hr_security.view_all, 'Y', 'TRUE',
1375: hr_security.Show_record('PER_ALL_ASSIGNMENTS_F',
1376: a.assignment_id,
1377: a.person_id,
1378: a.assignment_type))
1379: ORDER BY poeh.superior_level, p.full_name;

Line 1412: per_all_assignments_f a,

1408: CURSOR hier_pos(p_emp_id NUMBER, p_path_id NUMBER) IS
1409: SELECT /*+ ordered use_nl (poeh a p past b) */ poeh.superior_id
1410: FROM po_employee_hierarchies_all poeh,
1411: per_all_people_f p,
1412: per_all_assignments_f a,
1413: per_assignment_status_types past,
1414: per_periods_of_service b
1415: WHERE a.person_id = p.person_id
1416: AND poeh.business_group_id in (select fsp.business_group_id

Line 1441: hr_security.Show_record('PER_ALL_ASSIGNMENTS_F',

1437: p.employee_number,
1438: p.applicant_number,
1439: p.npw_number))
1440: AND 'TRUE' = Decode(hr_security.view_all, 'Y', 'TRUE',
1441: hr_security.Show_record('PER_ALL_ASSIGNMENTS_F',
1442: a.assignment_id,
1443: a.person_id,
1444: a.assignment_type))
1445: ORDER BY p.full_name;