DBA Data[Home] [Help]

APPS.OTA_TMT_BUS1 dependencies on PER_BUDGET_VALUES

Line 99: ,PER_BUDGET_VALUES pbva

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
102: and pb.budget_type_code = 'OTA_BUDGET'
103: and pb.budget_id = pbv.budget_id

Line 536: ,PER_BUDGET_VALUES pba

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
539: and pb.budget_id = pbv.budget_id
540: and pbv.budget_version_id = pbe.budget_version_id