DBA Data[Home] [Help]

APPS.OTA_TMT_BUS1 dependencies on PER_BUDGET_VERSIONS

Line 97: ,PER_BUDGET_VERSIONS pbv

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
101: and pb.business_group_id = p_business_group_id

Line 266: ,PER_BUDGET_VERSIONS pbs

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
270: and pb.budget_type_code = 'OTA_BUDGET'

Line 534: ,PER_BUDGET_VERSIONS pbv

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
538: and pb.business_group_id = p_business_group_id