APPS.PA_CONTROL_ITEMS_WORKFLOW dependencies on PA_PROJECT_LISTS_V

Line 1289: l_customer pa_project_lists_v.customer_name%TYPE;

1285: l_url VARCHAR2(2000);
1286: l_act_url VARCHAR2(2000);
1287: l_project_name pa_projects_all.name%TYPE;
1288: l_project_number pa_projects_all.segment1%TYPE;
1289: l_customer pa_project_lists_v.customer_name%TYPE;
1290: l_project_manager pa_project_lists_v.person_name%TYPE;
1291: l_org pa_project_lists_v.carrying_out_organization_name%TYPE;
1292: l_owner_id pa_control_items.owner_id%TYPE;
1293:

Line 1290: l_project_manager pa_project_lists_v.person_name%TYPE;

1286: l_act_url VARCHAR2(2000);
1287: l_project_name pa_projects_all.name%TYPE;
1288: l_project_number pa_projects_all.segment1%TYPE;
1289: l_customer pa_project_lists_v.customer_name%TYPE;
1290: l_project_manager pa_project_lists_v.person_name%TYPE;
1291: l_org pa_project_lists_v.carrying_out_organization_name%TYPE;
1292: l_owner_id pa_control_items.owner_id%TYPE;
1293:
1294: l_action_number pa_ci_actions_v.ci_action_number%TYPE;

Line 1291: l_org pa_project_lists_v.carrying_out_organization_name%TYPE;

1287: l_project_name pa_projects_all.name%TYPE;
1288: l_project_number pa_projects_all.segment1%TYPE;
1289: l_customer pa_project_lists_v.customer_name%TYPE;
1290: l_project_manager pa_project_lists_v.person_name%TYPE;
1291: l_org pa_project_lists_v.carrying_out_organization_name%TYPE;
1292: l_owner_id pa_control_items.owner_id%TYPE;
1293:
1294: l_action_number pa_ci_actions_v.ci_action_number%TYPE;
1295: l_action_request pa_ci_actions_v.comment_text%TYPE;

Line 1363: FROM pa_project_lists_v

1359: SELECT
1360: customer_name,
1361: person_name,
1362: carrying_out_organization_name
1363: FROM pa_project_lists_v
1364: WHERE project_id = l_project_id;
1365:
1366: --This cursor gets the info about the action.
1367: CURSOR cur_ci_action_info(c_action_id pa_ci_actions.ci_action_id%TYPE)