APPS.PO_DOCUMENT_ACTION_PVT dependencies on HR_SECURITY

Line 1375: AND 'TRUE' = Decode(hr_security.view_all, 'Y', 'TRUE',

1371: AND poeh.position_structure_id = p_path_id
1372: AND poeh.employee_id = p_emp_id
1373: AND p.person_id = poeh.superior_id
1374: AND poeh.superior_level > 0
1375: AND 'TRUE' = Decode(hr_security.view_all, 'Y', 'TRUE',
1376: hr_security.Show_person(p.person_id,
1377: p.current_applicant_flag,
1378: p.current_employee_flag,
1379: p.current_npw_flag,

Line 1376: hr_security.Show_person(p.person_id,

1372: AND poeh.employee_id = p_emp_id
1373: AND p.person_id = poeh.superior_id
1374: AND poeh.superior_level > 0
1375: AND 'TRUE' = Decode(hr_security.view_all, 'Y', 'TRUE',
1376: hr_security.Show_person(p.person_id,
1377: p.current_applicant_flag,
1378: p.current_employee_flag,
1379: p.current_npw_flag,
1380: p.employee_number,

Line 1383: AND 'TRUE' = Decode(hr_security.view_all, 'Y', 'TRUE',

1379: p.current_npw_flag,
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))

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 1441: AND 'TRUE' = Decode(hr_security.view_all, 'Y', 'TRUE',

1437: AND poeh.position_structure_id = p_path_id
1438: AND poeh.employee_id = p_emp_id
1439: AND p.person_id = poeh.superior_id
1440: AND poeh.superior_level = 1
1441: AND 'TRUE' = Decode(hr_security.view_all, 'Y', 'TRUE',
1442: hr_security.Show_person(p.person_id,
1443: p.current_applicant_flag,
1444: p.current_employee_flag,
1445: p.current_npw_flag,

Line 1442: hr_security.Show_person(p.person_id,

1438: AND poeh.employee_id = p_emp_id
1439: AND p.person_id = poeh.superior_id
1440: AND poeh.superior_level = 1
1441: AND 'TRUE' = Decode(hr_security.view_all, 'Y', 'TRUE',
1442: hr_security.Show_person(p.person_id,
1443: p.current_applicant_flag,
1444: p.current_employee_flag,
1445: p.current_npw_flag,
1446: p.employee_number,

Line 1449: AND 'TRUE' = Decode(hr_security.view_all, 'Y', 'TRUE',

1445: p.current_npw_flag,
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))

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;