APPS.ECE_SPSO_TRANS1 dependencies on PER_ALL_PEOPLE_F

Line 1382: per_all_people_f ppf

1378: x_asl_attribute14,
1379: x_asl_attribute15
1380: FROM
1381: po_asl_attributes paa,
1382: per_all_people_f ppf
1383: WHERE
1384: paa.vendor_id = l_header_tbl(n_vendor_id_pos).value
1385: AND paa.vendor_site_id = l_header_tbl(n_vendor_site_id_pos).value
1386: AND paa.item_id = g_item_id --Bug 1705597

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 1468: per_all_people_f ppf

1464: x_planner_first_name,
1465: x_planner_work_telephone
1466: FROM mtl_system_items msi,
1467: mtl_planners mpl,
1468: per_all_people_f ppf
1469: WHERE msi.organization_id = l_header_tbl(n_organization_id_pos).value
1470: AND msi.inventory_item_id = g_item_id -- Bug 1705597
1471: AND mpl.organization_id = l_header_tbl(n_organization_id_pos).value
1472: AND msi.planner_code = mpl.planner_code(+)

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';