DBA Data[Home] [Help]

APPS.PA_BUDGET_UTILS2 dependencies on PA_BUDGET_ENTRY_METHODS

Line 36: pa_budget_entry_methods m,

32: /* Commenting out code for FP.M, Tracking Bug No - 3354518 : Starts */
33: /* cursor c_chk_bud(p_entry_level varchar2) is
34: select 'Y'
35: from pa_budget_versions v,
36: pa_budget_entry_methods m,
37: pa_budget_types bt
38: where v.project_id = x_project_id
39: and v.budget_status_code = 'W'
40: and m.entry_level_code = p_entry_level

Line 65: pa_budget_entry_methods m,

61: /* Changes for FP.M, Tracking Bug No - 3354518 */
62: cursor c_chk_bud_p is
63: select 'Y'
64: from pa_budget_versions v,
65: pa_budget_entry_methods m,
66: pa_budget_types bt
67: where v.project_id = x_project_id
68: and v.budget_status_code = 'W'
69: and m.entry_level_code = 'P'

Line 97: pa_budget_entry_methods m,

93: /* Changes for FP.M, Tracking Bug No - 3354518 */
94: cursor c_chk_bud_t is
95: select 'Y'
96: from pa_budget_versions v,
97: pa_budget_entry_methods m,
98: pa_budget_types bt
99: where v.project_id = x_project_id
100: and v.budget_status_code = 'W'
101: and m.entry_level_code in ('T','L','M')

Line 310: pa_budget_entry_methods m,

306: from dual
307: where exists
308: (select 'x' /* Old budgets model */
309: from pa_budget_versions v,
310: pa_budget_entry_methods m,
311: pa_resource_assignments r
312: where r.task_id = x_task_id
313: and ( (m.entry_level_code = 'L')
314: or

Line 347: pa_budget_entry_methods m,

343: from dual
344: where exists
345: (select 'x' /* Old budgets model */
346: from pa_budget_versions v,
347: pa_budget_entry_methods m,
348: pa_resource_assignments r
349: where r.task_id = x_task_id
350: and ( (m.entry_level_code = 'L')
351: or