DBA Data[Home] [Help]

APPS.OTA_TMT_BUS1 dependencies on PER_BUDGETS

Line 96: from PER_BUDGETS pb

92: l_proc varchar2(72) := g_package||'chk_del_tp_measurement_code';
93: --
94: cursor csr_del_tp_measurement_code is
95: select null
96: from PER_BUDGETS pb
97: ,PER_BUDGET_VERSIONS pbv
98: ,PER_BUDGET_ELEMENTS pbe
99: ,PER_BUDGET_VALUES pbva
100: where pb.unit = p_tp_measurement_code

Line 265: from PER_BUDGETS pb

261: l_api_updating boolean;
262:
263: cursor csr_upd_tp_budget_level is
264: select null
265: from PER_BUDGETS pb
266: ,PER_BUDGET_VERSIONS pbs
267: ,PER_BUDGET_ELEMENTS pbe
268: where pb.unit = p_tp_measurement_code
269: and pb.business_group_id = p_business_group_id

Line 533: from PER_BUDGETS pb

529: l_api_updating boolean;
530:
531: cursor csr_upd_tp_budget_flag is
532: select count(pba.budget_value_id)
533: from PER_BUDGETS pb
534: ,PER_BUDGET_VERSIONS pbv
535: ,PER_BUDGET_ELEMENTS pbe
536: ,PER_BUDGET_VALUES pba
537: where pb.unit = p_tp_measurement_code