APPS.ECE_SPSO_TRANS1 dependencies on HR_SECURITY

Line 1395: AND decode(hr_security.view_all,'Y','TRUE',hr_security.show_record('PER_ALL_PEOPLE_F',

1391: g_item_id) -- Bug 1705597
1392: AND scheduler_id = ppf.person_id(+)
1393: AND ppf.effective_start_date (+) >= trunc(SYSDATE)
1394: AND ppf.effective_end_date (+) <= trunc(SYSDATE)
1395: AND decode(hr_security.view_all,'Y','TRUE',hr_security.show_record('PER_ALL_PEOPLE_F',
1396: ppf.person_id (+),
1397: ppf.person_type_id (+),
1398: ppf.employee_number (+),
1399: ppf.applicant_number (+) ))= 'TRUE';

Line 1476: AND decode(hr_security.view_all,'Y','TRUE',hr_security.show_record('PER_ALL_PEOPLE_F',

1472: AND msi.planner_code = mpl.planner_code(+)
1473: AND mpl.employee_id = ppf.person_id(+)
1474: AND ppf.effective_start_date (+) >= trunc(SYSDATE)
1475: AND ppf.effective_end_date (+) <= trunc(SYSDATE)
1476: AND decode(hr_security.view_all,'Y','TRUE',hr_security.show_record('PER_ALL_PEOPLE_F',
1477: ppf.person_id (+),
1478: ppf.person_type_id (+),
1479: ppf.employee_number (+),
1480: ppf.applicant_number (+) ))= 'TRUE';