DBA Data[Home] [Help]

APPS.RCV_TRANSACTION_SV dependencies on PA_TASKS_EXPEND_V

Line 35: /* Bug 4753498: Replaced pa_tasks_expend_v with pa_tasks in following query */

31: x_task_id PO_DISTRIBUTIONS.task_id%type; -- bug 5220069
32: begin
33: x_progress := 10;
34:
35: /* Bug 4753498: Replaced pa_tasks_expend_v with pa_tasks in following query */
36:
37: select pod.destination_type_code,
38: pod.destination_type_code,
39: plc.displayed_field,

Line 730: pa_tasks_expend_v pt

726:
727: select pa.project_number,pt.task_number
728: into x_project_number,x_task_number
729: from pjm_projects_all_v pa,
730: pa_tasks_expend_v pt
731: where pa.project_id = X_project_id
732: and pt.task_id = X_task_id
733: and pa.project_id=pt.project_id;
734:

Line 1113: l_po_task_number PA_TASKS_EXPEND_V.task_number%TYPE;

1109:
1110: --
1111: l_po_kanban_card_number MTL_KANBAN_CARDS.kanban_card_number%TYPE;
1112: l_po_project_number PJM_PROJECTS_ALL_V.project_number%TYPE;
1113: l_po_task_number PA_TASKS_EXPEND_V.task_number%TYPE;
1114: l_po_charge_account GL_CODE_COMBINATIONS_KFV.concatenated_segments%TYPE;
1115: --
1116:
1117: BEGIN