DBA Data[Home] [Help]

APPS.PA_BUDGET_CHECK_PVT dependencies on PA_TASKS

Line 94: FROM pa_tasks

90: ( p_task_id NUMBER )
91: IS
92: SELECT trunc(start_date) --Added trunc for Bug 3899746
93: , trunc(completion_date) --Added trunc for Bug 3899746
94: FROM pa_tasks
95: WHERE task_id = p_task_id;
96:
97:
98: l_api_name CONSTANT VARCHAR2(30) := 'get_valid_period_dates';

Line 120: (p_pa_task_id pa_tasks.task_id%type)

116: FROM pa_projects p
117: WHERE p.project_id = p_pa_project_id;
118:
119: CURSOR l_amg_task_csr
120: (p_pa_task_id pa_tasks.task_id%type)
121: IS
122: SELECT task_number
123: FROM pa_tasks p
124: WHERE p.task_id = p_pa_task_id;

Line 123: FROM pa_tasks p

119: CURSOR l_amg_task_csr
120: (p_pa_task_id pa_tasks.task_id%type)
121: IS
122: SELECT task_number
123: FROM pa_tasks p
124: WHERE p.task_id = p_pa_task_id;
125:
126: --Declared these constants for bug 2833255. These variables will contain
127: --the truncated values for p_budget_start_date_in and p_budget_end_date_in