APPS.PO_DOCUMENT_ACTION_PVT dependencies on HR_SECURITY

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

1362: AND poeh.position_structure_id = p_path_id
1363: AND poeh.employee_id = p_emp_id
1364: AND p.person_id = poeh.superior_id
1365: AND poeh.superior_level > 0
1366: AND 'TRUE' = Decode(hr_security.view_all, 'Y', 'TRUE',
1367: hr_security.Show_person(p.person_id,
1368: p.current_applicant_flag,
1369: p.current_employee_flag,
1370: p.current_npw_flag,

Line 1367: hr_security.Show_person(p.person_id,

1363: AND poeh.employee_id = p_emp_id
1364: AND p.person_id = poeh.superior_id
1365: AND poeh.superior_level > 0
1366: AND 'TRUE' = Decode(hr_security.view_all, 'Y', 'TRUE',
1367: hr_security.Show_person(p.person_id,
1368: p.current_applicant_flag,
1369: p.current_employee_flag,
1370: p.current_npw_flag,
1371: p.employee_number,

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

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

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

1428: AND poeh.position_structure_id = p_path_id
1429: AND poeh.employee_id = p_emp_id
1430: AND p.person_id = poeh.superior_id
1431: AND poeh.superior_level = 1
1432: AND 'TRUE' = Decode(hr_security.view_all, 'Y', 'TRUE',
1433: hr_security.Show_person(p.person_id,
1434: p.current_applicant_flag,
1435: p.current_employee_flag,
1436: p.current_npw_flag,

Line 1433: hr_security.Show_person(p.person_id,

1429: AND poeh.employee_id = p_emp_id
1430: AND p.person_id = poeh.superior_id
1431: AND poeh.superior_level = 1
1432: AND 'TRUE' = Decode(hr_security.view_all, 'Y', 'TRUE',
1433: hr_security.Show_person(p.person_id,
1434: p.current_applicant_flag,
1435: p.current_employee_flag,
1436: p.current_npw_flag,
1437: p.employee_number,

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

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

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;