APPS.PA_CONTROL_ITEMS_WF_CLIENT dependencies on PA_PROJECT_LISTS_V

Line 57: pa_project_lists_v.carrying_out_organization_name%TYPE

53: customer_id with fnd_user.person_party_id
54: for R12 ATG Mandate.
55: 08/05/05 raluthra Bug 4358517: Changed the definition of
56: l_org local variable from VARCHAR2(60) to
57: pa_project_lists_v.carrying_out_organization_name%TYPE
58: 10/15/08 rthumma Bug 6843085: Added changes in set_ci_approver to set the
59: control item status to previous status when there is no project manager.
60: 01/13/11 SPOKANAT Bug 10269493: Changed expiration date for adhoc roles to sysdate+15
61: 24/05/11 NISINHA Bug#12553990 : Added a join on Language in cursor get_ci_info

Line 348: FROM pa_project_lists_v

344: SELECT
345: customer_name,
346: person_name,
347: carrying_out_organization_name
348: FROM pa_project_lists_v
349: WHERE project_id = l_project_id;
350:
351: l_project_name VARCHAR2(30);
352: l_project_number VARCHAR2(25);

Line 358: l_org pa_project_lists_v.carrying_out_organization_name%TYPE; -- Bug 4358517.

354: l_task_number VARCHAR2(25);
355: l_task_name VARCHAR2(30);
356: l_customer VARCHAR2(4000);
357: l_project_manager VARCHAR2(240);
358: l_org pa_project_lists_v.carrying_out_organization_name%TYPE; -- Bug 4358517.
359:
360: BEGIN
361:
362: x_return_status := FND_API.G_RET_STS_SUCCESS;