APPS.PSP_XMLGEN dependencies on PER_PEOPLE_F

Line 653: FROM per_people_f ppf,

649:
650: /* Added for TGEN Bug 6864426 for pre-approved effort report*/
651: CURSOR initiator_name_cur IS
652: SELECT ppf.full_name
653: FROM per_people_f ppf,
654: fnd_user fu,
655: fnd_concurrent_requests fcr
656: WHERE fu.user_id = fcr.requested_by
657: AND fu.employee_id = ppf.person_id

Line 669: l_initiator_name per_people_f.full_name%TYPE; --Bug 6864426

665: l_business_group_id Number := FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID');
666: l_grouping_category varchar2(30); -- Added for Hospital effort report
667: l_layout_option_order Number;
668: l_approval_type psp_report_templates.approval_type%TYPE; --Bug 6864426
669: l_initiator_name per_people_f.full_name%TYPE; --Bug 6864426
670:
671: BEGIN
672: g_request_id := fnd_global.conc_request_id;
673: OPEN layout_type_cur;