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 703: pa_tasks_expend_v pt

699:
700: select pa.project_number,pt.task_number
701: into x_project_number,x_task_number
702: from pjm_projects_all_v pa,
703: pa_tasks_expend_v pt
704: where pa.project_id = X_project_id
705: and pt.task_id = X_task_id
706: and pa.project_id=pt.project_id;
707:

Line 1086: l_po_task_number PA_TASKS_EXPEND_V.task_number%TYPE;

1082:
1083: --
1084: l_po_kanban_card_number MTL_KANBAN_CARDS.kanban_card_number%TYPE;
1085: l_po_project_number PJM_PROJECTS_ALL_V.project_number%TYPE;
1086: l_po_task_number PA_TASKS_EXPEND_V.task_number%TYPE;
1087: l_po_charge_account GL_CODE_COMBINATIONS_KFV.concatenated_segments%TYPE;
1088: --
1089:
1090: BEGIN