APPS.PA_REPORT_WORKFLOW_CLIENT dependencies on PA_PROJECT_LISTS_V

Line 66: pa_project_lists_v.carrying_out_organization_name%TYPE to allow

62: 'To' field value.
63: 05-Aug-2005 raluthra Bug 4527617. Replaced fnd_user.customer_id with
64: fnd_user.person_party_id for R12 ATG Mandate fix.
65: 09-Feb-2006 posingha Bug 4530998. Changed the l_org variable from VARCHAR(60) to
66: pa_project_lists_v.carrying_out_organization_name%TYPE to allow
67: longer organization names to be accepted.
68: 31-Mar-2006 posingha Bug 5027098, Added code to set the 'From' role attribute
69: value for notifications.
70: 22-Feb-2007 posingha Bug 5716959: Changed calls to deprecated

Line 422: l_org pa_project_lists_v.carrying_out_organization_name%TYPE; --VARCHAR2(60); Modified for bug 4530998

418:
419:
420: l_customer VARCHAR2(4000);
421: l_project_manager VARCHAR2(240);
422: l_org pa_project_lists_v.carrying_out_organization_name%TYPE; --VARCHAR2(60); Modified for bug 4530998
423:
424: CURSOR get_project_info(l_project_id number) IS
425: SELECT
426: customer_name,

Line 429: FROM pa_project_lists_v

425: SELECT
426: customer_name,
427: person_name,
428: carrying_out_organization_name
429: FROM pa_project_lists_v
430: WHERE project_id = l_project_id;
431:
432: CURSOR get_person_id_from_resource_id (l_resource_id number) IS
433: select resource_source_id from pa_project_parties

Line 1232: FROM pa_project_lists_v pplv,

1228: CURSOR get_proj_mgr
1229: IS
1230: SELECT
1231: usr.user_id, usr.person_party_id, usr.user_name,papf.email_address,papf.full_name person_name -- Bug 4527617. Replaced customer_id with person_party_id.
1232: FROM pa_project_lists_v pplv,
1233: per_all_people_f papf,
1234: fnd_user usr
1235: WHERE pplv.project_id = l_project_id
1236: and papf.person_id = usr.employee_id