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 413: l_org pa_project_lists_v.carrying_out_organization_name%TYPE; --VARCHAR2(60); Modified for bug 4530998

409:
410:
411: l_customer VARCHAR2(4000);
412: l_project_manager VARCHAR2(240);
413: l_org pa_project_lists_v.carrying_out_organization_name%TYPE; --VARCHAR2(60); Modified for bug 4530998
414:
415: CURSOR get_project_info(l_project_id number) IS
416: SELECT
417: customer_name,

Line 420: FROM pa_project_lists_v

416: SELECT
417: customer_name,
418: person_name,
419: carrying_out_organization_name
420: FROM pa_project_lists_v
421: WHERE project_id = l_project_id;
422:
423: CURSOR get_person_id_from_resource_id (l_resource_id number) IS
424: select resource_source_id from pa_project_parties

Line 1182: FROM pa_project_lists_v pplv,

1178: CURSOR get_proj_mgr
1179: IS
1180: SELECT
1181: 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.
1182: FROM pa_project_lists_v pplv,
1183: per_all_people_f papf,
1184: fnd_user usr
1185: WHERE pplv.project_id = l_project_id
1186: and papf.person_id = usr.employee_id