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: =============================================================================*/
61:

Line 343: FROM pa_project_lists_v

339: SELECT
340: customer_name,
341: person_name,
342: carrying_out_organization_name
343: FROM pa_project_lists_v
344: WHERE project_id = l_project_id;
345:
346: l_project_name VARCHAR2(30);
347: l_project_number VARCHAR2(25);

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

349: l_task_number VARCHAR2(25);
350: l_task_name VARCHAR2(30);
351: l_customer VARCHAR2(4000);
352: l_project_manager VARCHAR2(240);
353: l_org pa_project_lists_v.carrying_out_organization_name%TYPE; -- Bug 4358517.
354:
355: BEGIN
356:
357: x_return_status := FND_API.G_RET_STS_SUCCESS;