APPS.PSP_XMLGEN dependencies on PER_PEOPLE_F

Line 649: FROM per_people_f ppf,

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

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

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