DBA Data[Home] [Help]

APPS.RCV_TRANSACTION_SV dependencies on PA_TASKS

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 97: PA_TASKS PT

93: PT.TASK_NUMBER
94: into x_project_number,
95: x_task_number
96: from PA_PROJECTS_ALL PPA,
97: PA_TASKS PT
98: where PPA.PROJECT_ID = PT.PROJECT_ID
99: and PPA.project_id = x_project_id
100: and PT.task_id = x_task_id;
101: EXCEPTION

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