APPS.OTA_TMT_API dependencies on OTA_TMT_SHD

Line 542: where ota_tmt_shd.g_old_rec.tp_measurement_code = pb.unit

538: --
539: cursor csr_get_budget_rowid is
540: select pb.rowid row_id
541: from PER_BUDGETS pb
542: where ota_tmt_shd.g_old_rec.tp_measurement_code = pb.unit
543: and ota_tmt_shd.g_old_rec.business_group_id = pb.business_group_id
544: and ota_tmt_shd.g_old_rec.tp_measurement_type_id = p_tp_measurement_type_id
545: and pb.budget_type_code = 'OTA_BUDGET';
546: --

Line 543: and ota_tmt_shd.g_old_rec.business_group_id = pb.business_group_id

539: cursor csr_get_budget_rowid is
540: select pb.rowid row_id
541: from PER_BUDGETS pb
542: where ota_tmt_shd.g_old_rec.tp_measurement_code = pb.unit
543: and ota_tmt_shd.g_old_rec.business_group_id = pb.business_group_id
544: and ota_tmt_shd.g_old_rec.tp_measurement_type_id = p_tp_measurement_type_id
545: and pb.budget_type_code = 'OTA_BUDGET';
546: --
547: cursor csr_get_budget_version_rowid is

Line 544: and ota_tmt_shd.g_old_rec.tp_measurement_type_id = p_tp_measurement_type_id

540: select pb.rowid row_id
541: from PER_BUDGETS pb
542: where ota_tmt_shd.g_old_rec.tp_measurement_code = pb.unit
543: and ota_tmt_shd.g_old_rec.business_group_id = pb.business_group_id
544: and ota_tmt_shd.g_old_rec.tp_measurement_type_id = p_tp_measurement_type_id
545: and pb.budget_type_code = 'OTA_BUDGET';
546: --
547: cursor csr_get_budget_version_rowid is
548: select pbv.rowid row_id

Line 551: where ota_tmt_shd.g_old_rec.tp_measurement_code = pb.unit

547: cursor csr_get_budget_version_rowid is
548: select pbv.rowid row_id
549: from PER_BUDGETS pb
550: ,PER_BUDGET_VERSIONS pbv
551: where ota_tmt_shd.g_old_rec.tp_measurement_code = pb.unit
552: and ota_tmt_shd.g_old_rec.business_group_id = pb.business_group_id
553: and ota_tmt_shd.g_old_rec.tp_measurement_type_id = p_tp_measurement_type_id
554: and pb.budget_id = pbv.budget_id
555: and pb.budget_type_code = 'OTA_BUDGET';

Line 552: and ota_tmt_shd.g_old_rec.business_group_id = pb.business_group_id

548: select pbv.rowid row_id
549: from PER_BUDGETS pb
550: ,PER_BUDGET_VERSIONS pbv
551: where ota_tmt_shd.g_old_rec.tp_measurement_code = pb.unit
552: and ota_tmt_shd.g_old_rec.business_group_id = pb.business_group_id
553: and ota_tmt_shd.g_old_rec.tp_measurement_type_id = p_tp_measurement_type_id
554: and pb.budget_id = pbv.budget_id
555: and pb.budget_type_code = 'OTA_BUDGET';
556: --

Line 553: and ota_tmt_shd.g_old_rec.tp_measurement_type_id = p_tp_measurement_type_id

549: from PER_BUDGETS pb
550: ,PER_BUDGET_VERSIONS pbv
551: where ota_tmt_shd.g_old_rec.tp_measurement_code = pb.unit
552: and ota_tmt_shd.g_old_rec.business_group_id = pb.business_group_id
553: and ota_tmt_shd.g_old_rec.tp_measurement_type_id = p_tp_measurement_type_id
554: and pb.budget_id = pbv.budget_id
555: and pb.budget_type_code = 'OTA_BUDGET';
556: --
557: begin