APPS.PA_CONTROL_ITEMS_WORKFLOW dependencies on PA_PROJECT_LISTS_V

Line 1392: l_customer pa_project_lists_v.customer_name%TYPE;

1388: l_url VARCHAR2(2000);
1389: l_act_url VARCHAR2(2000);
1390: l_project_name pa_projects_all.name%TYPE;
1391: l_project_number pa_projects_all.segment1%TYPE;
1392: l_customer pa_project_lists_v.customer_name%TYPE;
1393: l_project_manager pa_project_lists_v.person_name%TYPE;
1394: l_org pa_project_lists_v.carrying_out_organization_name%TYPE;
1395: l_owner_id pa_control_items.owner_id%TYPE;
1396: l_owner_role wf_items.owner_role%TYPE; /* Bug 9689141 */

Line 1393: l_project_manager pa_project_lists_v.person_name%TYPE;

1389: l_act_url VARCHAR2(2000);
1390: l_project_name pa_projects_all.name%TYPE;
1391: l_project_number pa_projects_all.segment1%TYPE;
1392: l_customer pa_project_lists_v.customer_name%TYPE;
1393: l_project_manager pa_project_lists_v.person_name%TYPE;
1394: l_org pa_project_lists_v.carrying_out_organization_name%TYPE;
1395: l_owner_id pa_control_items.owner_id%TYPE;
1396: l_owner_role wf_items.owner_role%TYPE; /* Bug 9689141 */
1397: l_action_number pa_ci_actions_v.ci_action_number%TYPE;

Line 1394: l_org pa_project_lists_v.carrying_out_organization_name%TYPE;

1390: l_project_name pa_projects_all.name%TYPE;
1391: l_project_number pa_projects_all.segment1%TYPE;
1392: l_customer pa_project_lists_v.customer_name%TYPE;
1393: l_project_manager pa_project_lists_v.person_name%TYPE;
1394: l_org pa_project_lists_v.carrying_out_organization_name%TYPE;
1395: l_owner_id pa_control_items.owner_id%TYPE;
1396: l_owner_role wf_items.owner_role%TYPE; /* Bug 9689141 */
1397: l_action_number pa_ci_actions_v.ci_action_number%TYPE;
1398: l_action_request pa_ci_actions_v.comment_text%TYPE;

Line 1476: FROM pa_project_lists_v

1472: SELECT
1473: customer_name,
1474: person_name,
1475: carrying_out_organization_name
1476: FROM pa_project_lists_v
1477: WHERE project_id = l_project_id;
1478:
1479: --This cursor gets the info about the action.
1480: CURSOR cur_ci_action_info(c_action_id pa_ci_actions.ci_action_id%TYPE)